The query displays employee records with the same salary.

• Use the GROUP BY clause to group the records by salary.

• Use the HAVING clause to filter the groups with more than one employee.

• Select the necess...read more

SELECT * FROM employees WHERE salary IN (SELECT salary FROM employees GROUP BY salary HAVING count(salary)>1);

second method using partitions:

select first_name, salary, total_count from (select first_n...read more