Multiple choice sql

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

  1. SELECT * FROM Persons SORT BY 'FirstName' DESC

  2. SELECT * FROM Persons ORDER BY FirstName DESC

  3. SELECT * FROM Persons ORDER FirstName DESC

  4. SELECT * FROM Persons SORT 'FirstName' DESC
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ORDER BY is the correct clause for sorting, and DESC specifies descending order. The column name should not be quoted, and the keyword is ORDER BY not SORT BY.

Keep practicing — related questions