Find top scorer of each department
Filed under Informatica
The question
Given a table with columns st_id, dept_id, and marks_id, write an SQL query to find the top scorer for each department using self join and group by.
No write-up yet. Related questions below have one.
Related Informatica questions
Collected from public candidate posts and coding forums. Updated Nov 2026.