1 回答
TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超10個(gè)贊
您的子查詢中需要不同的 total_obtain_mark
GROUP_CONCAT( distinct total_obtain_mark ORDER BY total_obtain_mark DESC )
"SELECT id, total_obtain_mark, FIND_IN_SET( total_obtain_mark,(
SELECT GROUP_CONCAT( distinct total_obtain_mark ORDER BY total_obtain_mark DESC )
FROM exam_results WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id ))
AS rank
FROM exam_results
WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id AND total_obtain_mark = $mark";
否則,如果您有一些相同等級(jí)的學(xué)生,您將跳過(guò)位置
- 1 回答
- 0 關(guān)注
- 175 瀏覽
添加回答
舉報(bào)
