MySQL多查询？

Question

我的表格是：

exam_code     | roll |    name    | marks | negative_marks | 

model test 01   100    Md Kalam      88        3  

model test 01   101    Md Razzak     84        4

model test 02   100    Md Kalam      90        1

model test 01   102    Md Kalam      70        5

我想找出最高的分数和位置根据exam_code搜索exam_code和滚动

最终结果将如下所示

Name:  Md Kalam
roll: 100
Exam Name: model test 01
Mark: 88
Highest mark: 88
Merit Postion: 1

Answer 1

SELECT *
FROM MyTable
WHERE exam_code='$examcode' AND roll_number='$rollnumber'
ORDER BY marks desc
LIMIT 1