Top 3 highest marks per subject SQL query
Filed under Arcesium
The question
Given a table with roll_id, course_id, remarks, and score, write a SQL query to print the roll_id of students securing the top 3 highest marks in each subject.
No write-up yet. Related questions below have one.
Related Arcesium questions
Collected from public candidate posts and coding forums. Updated Nov 2026.