What is the SQL syntax for sorting, and which is the default order?

The default sorting order is ascending. These two statements are identical:

select from order by

select from order by asc

For descending order, simply replace “asc” with “desc.”