看看这个sql语句

Select   Count(ExamValue_Num)   as   CountNum,Student_ExaID,  
    ExamValue_Num,Standard_Value,ValueLevel_ID    
  from   T_ExamValue   where   Subject_ID   =   26   and   ExamTimes_ID   =   2   order   by   Student_ExaID  
   
  报错：选择列表中的列   'T_ExamValue.Student_ExaID'   无效，因为该列没有包含在聚合函数或   GROUP   BY   子句中。  
   
  怎么改呢？谢谢各位了 问题点数：20、回复次数：1Top

1 楼wula0010（wula0010）回复于 2006-03-21 17:52:03 得分 20

Select   Count(ExamValue_Num)   as   CountNum,Student_ExaID,  
    ExamValue_Num,Standard_Value,ValueLevel_ID    
  from   T_ExamValue   where   Subject_ID   =   26   and   ExamTimes_ID   =   2    
  group   by   Student_ExaID,   ExamValue_Num,Standard_Value,ValueLevel_ID    
  order   by   Student_ExaIDTop

相关问题

• examvalue
• exaid
• valuelevel
• student
• num
• standard
• where subject
• group
• order
• from t

• 帖主：nanhaoff
• wula0010

• CSDN .NET频道
• .NET类图书
• C#类图书
• .NET类源码下载