SQL Topper Employees Query | Dataford Interview Questions

Suppose you have an Employee table with id, name, salary, deptid; fetch employees who are toppers in their own department and write the SQL query.

Treat all employees tied for the highest salary in a department as toppers. Exclude employees without a department or salary.

Output

One row per qualifying employee, with columns id, name, salary, and deptid
Include all salary ties for the departmental maximum
Order by deptid ascending, then id ascending

employee

Your question is SQL Topper Employees Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Suppose you have an Employee table with id, name, salary, deptid; fetch employees who are toppers in their own department and write the SQL query.

Treat all employees tied for the highest salary in a department as toppers. Exclude employees without a department or salary.

One row per qualifying employee, with columns id, name, salary, and deptid
Include all salary ties for the departmental maximum
Order by deptid ascending, then id ascending

employee

Your question is SQL Topper Employees Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.