MS SQL Server
Hej,SELECT COUNT(*) AS 'Students Passed', Module_0215205.Name AS 'Module Name' FROM
Module_0215205, StudentModule_0215205
WHERE Module_0215205.Module_ID=StudentModule_0215205.Module_ID
AND StudentModule_0215205.Status = 'PASS' Group by Module_0215205.Name
denne "query" viser nr af studenter som er bestaaet i de fage som er registeret.
Resultatet ser saden ud:
Students Passed Module Name
--------------- ----------------------------------------
1 Database Systems
2 Network Planning & Managment
1 Quality Assurance
hvordan kan jeg gore det at ogsa nr af alle studenter vises, sa den ser sadan ud ved hjaelp af een "query":
Total Students Passed Module Name
----- ------------- --------------------------------
1 2 Systems Database
1 2 Network Planning
1 4 Quality Assurance