How to Calculate CGPA

Vote count:

0

Dear i want to Calculate CGPA at to end of Each Semester How to Calculate CGAP of All Semseters

SELECT SNO, SEMESTER, SUM(CRH), SUM(GP), SUM(GP)/SUM(CRH) GPA from STUDENT_EXAM WHERE SNO = 1 GROUP BY SNO, SEMESTER;

Student No Semester Credit Hours Grade Point GPA CGPA 1 1 18 60 3.33

2 6 15 2.50

3 18 22 1.22

4 18 38 2.11

5 6 12 2.00

6 18 58 3.22

7 18 55 3.06

8 6 21 3.50

asked 9 secs ago

user3580194

1