Cellwise · SQL track

Sorting and limiting

Put results in order, take the top few, and remove duplicates.

ORDER BY sorts your results, and DESC sorts from highest to lowest. LIMIT keeps just the first few rows.

DISTINCT removes duplicates, which is the quick way to see all the values in a column.

What you’ll do

• Sort by a column
• Find the top three
• List each value once