limit限制显示条数
分页核心
SELECT & FROM cms LIMIT 3;
分页 第一页3条记录
SELECT & FROM cms LIMIT 0,3;
SELECT id,sex,age,GROUP_CONCAT(username),
COUNT(*) AS totalusers,
MAX(age) AS max_age,
MIN(age) AS min_age,
AVG(age) AS avg_age,
SUM(age) AS sum_age,
FROM cms_user
WHERE id>=1
GROUP BY sex
HAVING COUNT(*)>=2
ORDER BY age DESC
LIMIT 0,2;