如何为特定列的总和生成sql查询然后对其进行排名

Question

i have a table mark_summery, Here is my table structure

now i just want to sum the "obt_marks" and "total_marks" of specific student with multiple exams (maximum four). "multiple exams mean summation of four exams " how can i sql it. any idea.?

Answer 1

Try using this code

select s.StudentID, s.name, sum(marks)
from tbl_marks m inner join tbl_student s
on m.studentid=s.studentid
group by s.studentid
having sum(marks)=
(
select max(tbl.totalmarks) from 
(select studentid, sum(marks) as totalmarks from tbl_marks group by studentid) tbl
)

Try using this code