SQL-complete-tutorial
13 строк · 211.0 Байт
1SELECT *
2FROM sql_store.customers
3LIMIT 3;
4
5-- page 1: 1-3
6-- page 2: 4-6
7-- page 3: 7-9
8
9-- Get the top three loyal customers (the highest points)
10SELECT *
11FROM sql_store.customers
12ORDER BY points DESC
13LIMIT 3;