To sort your result records, use **ORDER BY** construction. There is a syntax of query:

-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ... 

`ORDER BY` is at the end of the query, and sorts by one or multiple columns in their order. For example, if there is a construction `ORDER BY singer, title`, the result will be sorted by `singer`'s name, but for multiple songs of the same `singer`, records will be sorted by `title`.

By default, sorting is in ascending order, but you can define it. Use `ASC` and `DESC` keywords after each column name: 

SELECT id, title, year
FROM songs
ORDER BY year DESC

`ASC` or `DESC` statement relates to the column name before it. It means, that in `ORDER BY title ASC, price DESC` first sorts by `title` in ascending order, and then by `price` in descending order.

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Order By

解答