Sr.no  Subject  No of class attended    
-------------------------------------
1       English           3
2       Maths             4
3       SocialScience     5

我希望这种格式的表格

English    Maths   SocialScience
---------------------------------
3            4          5

我试过这个：

Select case when subject ='Maths' then COUNT(No_of_Candidates) else null  end as Maths

但有了这个,我得到这样的数据：

English    Maths   SocialScience
---------------------------------
   3            
               4
                         5

请帮帮我怎么解决这个问题..

解决方法

English    Maths   SocialScience
---------------------------------
   3            
               4
                         5

SELECT English,Maths,SocialScience
FROM (
SELECT Subject,No_of_class_attended
  FROM mytable) up
PIVOT 
(Sum([No_of_class_attended]) 
 for Subject in ([English],[Maths],[SocialScience])) p

English  Maths  SocialScience
---------------------------------
3      4     5

• 上一篇：实体框架 – 实体框架和SQL Server下一篇：sql – INSERT IF NOT EXISTS但是返