SQL中的排序和分组
一、排序 order by
- 语法:select 字段 from 表名称 where 筛查条件 order by 排序字段列表(顺序不能乱)desc(ace)
select * from student where name like '%文%' order by name desc
二、分组 group by
- 语法:select 字段 from 表名称 where 筛查条件 group by 分组字段列表 order by 排序字段列表(顺序不能乱)desc(ace)
select classID,sex,count(*) from student where classID in ('1','2','3') group by classID,sex order by studentNo