Pergunta de entrevista da empresa NVIDIA
In SQL, how would you go about identifying and removing duplicate records?
Resposta da entrevista
Sigiloso
30 de jan. de 2021
*For identifying SELECT [FirstName], [LastName], [Country], COUNT(*) AS CNT FROM [SampleDB].[dbo].[Employee] GROUP BY [FirstName], [LastName], [Country] HAVING COUNT(*) > 1; *For deleting DELETE FROM [SampleDB].[dbo].[Employee] WHERE ID NOT IN ( SELECT MAX(ID) AS MaxRecordID FROM [SampleDB].[dbo].[Employee] GROUP BY [FirstName], [LastName], [Country] );