Tag Archives: SQL / PLSQL

Useful Tips of ORDER BY clause

1. ORDER BY clause can be used by column numbers instead of column names. For example, we have a query: SQL> Select empname, sal from emp order by 2; It means that the result set will be in ascending order by … Continue reading

Posted in SQL / PLSQL | Tagged , | Leave a comment