ORDER BY Clause
To order the Query results, add an ORDER BY clause.
The general form of the ORDER BY clause is:
The default ordering direction is ascending.
ORDER BY Examples
select * from Person where age > 30 order by age asc, name desc
select age from Person where ((age > 100 and zip=20144) or time > 10)
order by age descending
select age, zip from Person where ((age > 100 and zip=20144) or time > 10)
order by age desc, zip asc