Coder Circle

Arranging output in SQL

Remember ORDER BY is the last clause in the SELECT statement, which arranges the order after the SQL data are fetched The ORDER BY clause arranges the  output of a SELECT statement in a particular order. It can be ascending or descending. SELECT EMPNO,ENAME,SAL FROM EMP ORDER BY SAL;   The above SQL will display the result in the [...]