Put in order · SQL and MySQL course · Module 2: Querying data (SELECT)
Clauses of a sorting query
Arrange the clauses of a sorting query in the correct order in which we write them in MySQL (top to bottom):
Items to put in order
- FROM ksiazki
- ORDER BY rok_wydania DESC
- SELECT tytul, rok_wydania
Show the answer
Correct order:
- SELECT tytul, rok_wydania
- FROM ksiazki
- ORDER BY rok_wydania DESC