ORDER BY: It is used to sort columns of a result set. It sorts columns in ascending order by default. DESC can be used to sort in a descending order.
Syntax:
SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
Example:
SELECT balance FROM Account ORDER BY balance DESC
SELECT balance FROM Account ORDER BY balance DESC

0 Comments:
Post a Comment