視圖.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
在映射到 URL 模式并開始運行服務器后，我正在嘗試使用 views.py 中的原始函式計算最大標記，但它只獲得一條記錄，但仍有更多記錄具有最大標記，有人可以建議我該怎么做嗎？
uj5u.com熱心網友回復：
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);
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/406806.html
標籤：