用一个sql实现统计某个学校每年入学的男女生人数各为多少人?
假如表为student
sql如下:
select year,
sum(case when sex ='男' then 1 else 0) as '男',
sum(case when sex ='女' then 1 else 0) as '女'
form student
group by year
以上的sex为表中性别字段,year为入学年份字段
用一个sql实现统计某个学校每年入学的男女生人数各为多少人?
假如表为student
sql如下:
select year,
sum(case when sex ='男' then 1 else 0) as '男',
sum(case when sex ='女' then 1 else 0) as '女'
form student
group by year
以上的sex为表中性别字段,year为入学年份字段