ORDER BY and LIMIT / OFFSET | Learn SQL Visual

Sorting and Paging

ORDER BY sorts the result. If the direction is omitted, it uses ascending order (ASC); DESC uses descending order. LIMIT n returns the first n rows after sorting, and OFFSET n skips the first n. Together they page through a result. Without ORDER BY, row order is not guaranteed.

Which product has rank 1 after ORDER BY price DESC?

CHECK IT

SELECT name, price
FROM products
ORDER BY price ASC

productssorted, all 7 rows

rank	name	price
1	SQL Guide	39
2	DB Internals	55
3	Old Tablet	199
4	Pixel Phone	799
5	iPhone	999
6	ThinkPad	1299
7	MacBook	1499

ORDER BY sorts the result. If the direction is omitted, it uses ascending order (ASC).