select (case teacher_type when 1 then '校内专任' else '校内兼职' end)as 职位,sum(case degree when 0 then 1 else 0 end) as 博士研究生,sum(case degree when 1 then 1 else 0 end) as 硕士研究生,
sum(case degree when 2 then 1 else 0 end) as 本科,sum(case degree when 3 then 1 else 0 end) as 专科,
sum(case degree when 4 then 1 else 0 end) as 专科以下 from teachers where year=2011 group by teacher_type
select Tem.Name,sum(进) as 进,sum(出) as 出 from (
select Uwork,case Utyn when '进' then 1 else 0 end '进',
case Utyn when '出' then 1 else 0 end '出' from user) Tem
group by aa.Name
用以上语句搞定。
select Name, sum(进) '进', sum(出) '出' from
(
select Name,
case type when '进' then 1 else 0 end '进',
case type when '出' then 1 else 0 end '出'
from TableName
) tmp
group by 进, 出