SQL Sorting and Limiting Results 2

Question 1

By default, in which direction does ORDER BY sort results?

Accepted Answer

Ascending (ASC)

Answer

ORDER BY sorts in ascending order by default unless DESC is specified.

Question 2

Which clause limits the number of rows returned in standard MySQL/PostgreSQL?

Accepted Answer

LIMIT

Answer

LIMIT restricts the number of rows returned in MySQL and PostgreSQL.

Question 3

How do you sort by 'last_name' ascending and then 'first_name' descending?

Accepted Answer

ORDER BY last_name ASC, first_name DESC

Answer

Each column in ORDER BY can have its own sort direction.

Question 4

In SQL Server, which keyword limits the number of rows returned?

Accepted Answer

TOP

Answer

SQL Server uses TOP n to restrict the number of returned rows.

Question 5

What does ORDER BY 2 mean in a query?

Accepted Answer

Sort by the second column in the SELECT list

Answer

A number in ORDER BY refers to the position of a column in the SELECT list.

SQL Practice Test