Write a query to fetch duplicate records from a table using MySQL?

1.	Write a query to fetch duplicate records from a table using MySQL?
Answer» SELECT EmpId, Project, Salary, COUNT() FROM EmployeeSalary GROUP BY EmpId, Project, Salary HAVING COUNT() &GT; 1;

Discussion