How to fix using raw function MAX in queryset API not getting maximum marks?-CodePudding

views.py

class MaxMarks(generics.ListAPIView):
    queryset = Marks.objects.raw('select student_id, subject_id, 
    sem_marks, id, internal_marks, MAX(total_marks) from 
    collegedetails.college_marks ')
    serializer_class = MarksSerializers

I'm trying to figure out max marks using raw funtion in views.py after mapping to URL pattern and start run server but it getting only one record but still there more records which haveing max marks, Can any one suggest me what to do?

CodePudding user response：

SELECT t1.student_id, 
       t1.subject_id, 
       t1.sem_marks, 
       t1.id, 
       t1.internal_marks, 
       total_marks
FROM collegedetails.college_marks t1
JOIN ( SELECT MAX(t2.total_marks) total_marks
       FROM collegedetails.college_marks t2 ) t3 USING (total_marks);