MySQL LIMIT限制查询结果显示数目

LIMIT 显示条数

LIMIT 偏移量， 显示条数  

注 偏移量从0开始

SELECT * FROM city LIMIT 1,2;

SELECT * FROM city ORDER BYname 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;