How to calculate Total exam and display grade

Abdurahman Yusuf Abdi

8y830

I wanna to calculate the total marks of examination table and also to display the grade for example

100 A

89 B

and finally show the GPA of the students

Please help me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa8y ago
Hello

You can add both column value and display it into a new column like

SELECT TOP 1000 [Sno]
,[IDNumber]
,[StudentName]
,[Class]
,[AcademicYear]
,[Semester]
,[CourseCode]
,[CourseTitle]
,[CreditHour]
,[CourseType]
,[Attendance]
,[Assigment]
,[MidExam]
,[FinalExam]
,[TotalMarks]
,[Date]
,[DoneBy],
+TotalMarks+' '+grade as Total score
FROM [OnlineExam].[dbo].[Examination]
Or if you want to find grade based on number then use this query

SELECT
TotalMark,
(IF(TotalMark > 84.5, 'A', IF (TotalMark > 64.5, 'B',
IF(TotalMark > 49.5, 'C', IF (TotalMark > 29.5, 'D', 'E'))))) AS Grade
FROM Results
Abdurahman Yusuf Abdi8y ago
SELECT TOP 1000 [Sno]
,[IDNumber]
,[StudentName]
,[Class]
,[AcademicYear]
,[Semester]
,[CourseCode]
,[CourseTitle]
,[CreditHour]
,[CourseType]
,[Attendance]
,[Assigment]
,[MidExam]
,[FinalExam]
,[TotalMarks]
,[Date]
,[DoneBy]
FROM [OnlineExam].[dbo].[Examination]

that is my examination table then i want to add another column like Total marks Grade taht two column

thank you
Amit Gupta8y ago
It would be much helpful if you have been provide the input table, your logic to calculate grade and the expected output