โ† Arcesium questions

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.