Multiple choice

The statement to return all the records from a table named books sorted in descending by the column author is _____.

  1. select * from books order by author

  2. select * from books by order desc

  3. select * from books order by author desc

  4. select * from books sort by author desc
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Order By statement is used to display the records in a particular order. For example, the statement select * from students order by address will print all the records alphabetically on the basis of address. By adding a desc clause we can sort the records in descending order. The statement select * from players order by match desc and will print all the records from the players table in descending order of the match column.

Keep practicing — related questions