立即学习:https://edu.csdn.net/course/play/27328/362528?utm_source=blogtoedu
order by语法: 排序
SELECT column_name1,column_name2
FROM table_name1,table_name2
ORDER BY column_name,column_name[ASC|DESC]
limit语法: 分页
SELECT column_name1,column_name2
FROM table_name1,table_name2
LIMIT [offset,] row_count
分页公式:
limit(page-1)*row_count,row_count
order by sex,salary ;
多字段排序 优先第一字段排序 排序相同按第二字段排序