Pergunta de entrevista da empresa Capgemini

Write a query to retrieve duplicate records from a table?

Respostas da entrevista

Sigiloso

9 de jun. de 2023

SELECT column, COUNT(id_column) AS new_column FROM table_name GROUP BY column 1 HAVING COUNT(column 1)>1;

4

Sigiloso

12 de abr. de 2023

SELECT EmpID, EmpFname, Department COUNT(*) FROM EmployeeInfo GROUP BY EmpID, EmpFname, Department HAVING COUNT(*) > 1;