SqlConnection("Data Source=(LocalDB)\\v11.0;AttachDbFilename='C:\\Users\\Abdul Basit Mehmood\\Documents\\VisualWebSites\\WebSite1\\App_Data\\Database.mdf';Integrated Security= True");
List<StudentsList> stu
select distinct new ReportVO (stu.id, stu.first_name, stu.last_name, stu.year, stu.school.school_nameelse 0 end) as numApplications) " +
"from StudentCollege as si join si.student as stuwhere stu.year <=
我考虑过使用GROUP BY STU.ID, STU.FN, STU.LN,但是我不知道如何在SELECT中使用PGM.CD,因为它不是一个聚合函数,也不是按类排列的组。SELECT STU.ID, STU.FN, STU.LN, WHEN '200' THEN 'DLA' ENDLEFTJOIN PGM
ON ST
SELECT stu.sc, stu.sn, COUNT(*) AS Total, WHEN COUNT(*) = 3 Then 'Letter 1' WHEN COUNT(*) = 5 Then 'Letter 3' END AS Letter
FROM STUjoin att ON (stu.SC =