Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL remove duplicate

DELETE FROM [SampleDB].[dbo].[Employee]
    WHERE ID NOT IN
    (
        SELECT MAX(ID) AS MaxRecordID
        FROM [SampleDB].[dbo].[Employee]
        GROUP BY [FirstName], 
                 [LastName], 
                 [Country]
    );
Source by www.sqlshack.com #
 
PREVIOUS NEXT
Tagged: #SQL #remove #duplicate
ADD COMMENT
Topic
Name
8+4 =