排序order by
说明:COLUMNNAME 列名,TABLENAME 表名
- 默认升序asc
- select COLUMNNAME from TABLENAME order by COLUMNNAME;
- 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;