Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
How to Remove Delete Duplicate Records Or Rows-Sql Server.

Posted On: 05/09/2012 23:18:28
Suppose you have a table User in this table u have column ID, FirstName, Country

DELETE FROM dbo.User
WHERE ID NOT IN (SELECT MIN(ID)
FROM dbo.User GROUP BY FirstName,Country)
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us