SQL query for maximum salary per department
Filed under Yatra.com
The question
Given a table with columns empId, deptId, and salary, write a SQL query to list the maximum salary for each department.
No write-up yet. Related questions below have one.
Related Yatra.com questions
Collected from public candidate posts and coding forums. Updated Nov 2026.