【MySQL必知必会】第五章 排序检索数据（学习笔记）

排序order by

说明：COLUMNNAME 列名，TABLENAME 表名

1. 默认升序asc
2. select COLUMNNAME from TABLENAME order by COLUMNNAME;
3. select COLUMNNAME1,COLUMNNAME2 from TABLENAME order by COLUMNNAME1,COLUMNNAME2;

降序desc

select COLUMNNAME from TABLENAME order by COLUMNNAME desc;

limit放到order by后面

select COLUMNNAME from TABLENAME order by COLUMNNAME limit 5;