SELECT * FROM user ORDER BY age [ASC|DESC];
SELECT * FROM user ORDER BY 1;
多个字段排序
SELECT * FROM user ORDER BY age ASC , id DESC;
随机排序
SELECT * FROM user ORDER BY RAND();
综合例子
SELECT id, age, sex, GROUP_CONCAT(name) , COUNT(*) AS total
FROM user
WHERE id>0
GROUP BY sex
HAVING COUNT(*)>0
ORDER BY age DESC, id ASC;