โ† Informatica questions

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.