Sql Query : Write a query to fetch duplicate records from a table? | Find duplicate rows in sql

Query to fetch duplicate records from a table.

SELECT name,salary,count(*)
FROM employees
GROUP BY name,salary
HAVING count(*) greater than 1
Sal query || SQL interview question || helpumyway

mysql interview queries playlist:

[googdriveforme]

For million records this is not a good option..