Sunday, August 11, 2013

[SQL 2012] Pencentage

[SQL 2012] Pencentage


Pencentage

Posted: 10 Aug 2013 09:23 PM PDT

I have 3 tables:Student table(StudentNumber,Name,Contact,Address,DateOfBirth,YearEnrolled,Year Of Study)Absence table(SubjectCode,StudentNumber, DateOfAbsence)Subject table(SubjectCode, Subject Name,Description)I would need to display StudentNumber, Name, SubjectCode and the pecentatage of Date of Absence)taking that there are 10 lessonHow can i disply the above.

No comments:

Post a Comment

Search This Blog