|
ORDER BY
Order By clause is used to sort the tuples in ascending or descending order with respect to one or more attributes.
Syntax ::
[SELECT] <COLUMN1>....<COLUMNX>
FROM <TABLE>
ORDER BY [<COLUMN1>|..|<COLUMNX>] [ASC|DESC];
Example ::
SELECT CUST_ID,CUST_NAME,CUST_SAL
FROM CUSTOMER
ORDER BY CUST_NAME ASC;
|
|
