1. 
   
2. (select count(Student.mzId)as 人数,Minzu.name as 民族 from Minzu
   
3. INNER JOIN
   
4. dbo.Student ON dbo.Minzu.id = dbo.Student.mzId
   
5. group by Minzu.name )
   
6. 
   

复制代码

第一张图片为查询结果，现在想实现一个行列转换的功能如图第二章，求解答

1. select
   
2. 
   
3. SUM(case name when '藏族' then peopleCount end) as [藏族],
   
4. SUM(case name when '朝鲜族' then peopleCount end) as [朝鲜族],
   
5. SUM(case name when '汉族' then peopleCount end) as [汉族],
   
6. SUM(case name when '苗族' then peopleCount end) as [苗族],
   
7. SUM(case name when '维吾尔族' then peopleCount end) as [维吾尔族]
   
8. 
   
9. from Minzu

复制代码

changvh 发表于 2013-7-23 07:47

1. select
   
2. case Minzu.name when '藏族' then count(Student.mzId) end as [藏族],
   
3. case Minzu.name when '朝鲜族' then count(Student.mzId) end as [朝鲜族],
   
4. case Minzu.name when '汉族' then count(Student.mzId) end as [汉族],
   
5. case Minzu.name when '苗族' then count(Student.mzId) end as [苗族],
   
6. case Minzu.name when '维吾尔族' then count(Student.mzId) end as [维吾尔族]
   
7. from Minzu inner join Student on Minzu.id=Student.mzId
   
8. group by Minzu.name

复制代码

咖喱猫 发表于 2013-7-23 08:36

很感您同学的参与回答，不过这么写不符合要求了；现在的要求就是两表查询，并且是动态的

咖喱猫 发表于 2013-7-23 08:37
很感您同学的参与回答，不过这么写不符合要求了；现在的要求就是两表查询，并且是动态的 ...

可能是我错了吧，同学你的问题都是难度太大的，我无能为力