SELECT * FROM 彩虹糖 ORDER BY 甜度 DESC LIMIT 10;

LIMIT 10;  -- 不多不少，就要前 10 行。

LIMIT 5, 10;  -- 跳过前 5 行，再端 10 行；分页必备，谁用谁爽。

LIMIT 10 OFFSET 20;  -- 官方推荐写法，语义清晰，妈妈再也不用担心我读不懂。

SELECT TOP 10 * FROM 彩虹糖 ORDER BY 甜度 DESC;

SELECT * 
FROM 彩虹糖
ORDER BY 甜度 DESC
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT * FROM 彩虹糖 ORDER BY RAND() LIMIT 3;

SELECT * FROM user_profile LIMIT 5;

SELECT * FROM user_profile LIMIT 10 OFFSET 20;
-- 或
SELECT * FROM user_profile LIMIT 20, 10;

SELECT * FROM score ORDER BY grade DESC LIMIT 3;

SELECT TOP (5) * FROM user_profile;

SELECT * 
FROM user_profile
ORDER BY id
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT * FROM user_profile WHERE id  1000 ORDER BY id ASC LIMIT 10;