← Oracle questions

Find topper of each subject using SQL

Filed under Oracle

Given a student table with columns (name, subject, marks), write a SQL query to find the topper (highest marks) for each subject.

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Oracle questions

Collected from public candidate posts and coding forums. Updated Nov 2026.