[SQL 2012] 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. |
You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
No comments:
Post a Comment