TOP and ORDER BY

Sort a query's results with ORDER BY, ascending or descending, by one column or several, and keep only the first rows with TOP.

Updated

Cheat sheet: TOP and ORDER BY
Category
SQL
Level
Novice
Tags
ASC, DESC, order by, sql, TOP, t-sql