LIMIT 显示条数
LIMIT 偏移量, 显示条数
注 偏移量从0开始
SELECT * FROM city LIMIT 1,2;
SELECT * FROM city ORDER BY name LIMIT 1,2;
综合
SELECT id, sex,age GROUP_CONCAT(name).
COUNT(*) AS total,
MAX(age) AS maxAge,
FROM user
WHERE id>0
GROUP BY sex
HAVING COUNT(*)>0
ORDER BY age DESC
LIMIT 0,6;