Find Duplicate Salaries in SQL | Dataford Interview Questions

Write a SQL query to identify duplicate salaries in a table.

Use the employee_salaries table. Return only salary values that appear more than once, excluding NULL salaries.

Output

employee_salaries

Column	Type	Description
employee_idPK	INT	Unique employee identifier
salary	NUMERIC(12,2)	Employee salary amount

Your question is Find Duplicate Salaries in SQL. 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.

Write a SQL query to identify duplicate salaries in a table.

Use the employee_salaries table. Return only salary values that appear more than once, excluding NULL salaries.

employee_salaries

Column	Type	Description
employee_idPK	INT	Unique employee identifier
salary	NUMERIC(12,2)	Employee salary amount

Your question is Find Duplicate Salaries in SQL. 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.