We use ORDER BY to make our record list in a ordered manner in the sense of descending /ascending sort.
Syntax:-
SELECT column_name, column_name
FROM table_name
ORDER BY column_name ASC|DESC
Note:- User can ORDER BY more then one column in a single query like:-
SELECT column_name, column_name
FROM table_name
ORDER BY column_name1 ASC|DESC,column_name2 ASC|DESC;
0 Comment(s)