InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 15:55:29 GMT20http://www.sqlservercentral.com/Forums/Topic1421949-392-1.aspx[code="sql"]DROP table #emplCREATE TABLE #empl( row_id int, ename varchar(120), job varchar(120), sal varchar(100))INSERT #empl VALUES ('4','ram','IT','60000'), ('4','ram','IT','60000'), ('4','ram','IT','60000'), ('4','ram','IT','60000');WITH OrderedData AS ( SELECT row_id, ename, job, sal, rn = ROW_NUMBER() OVER(PARTITION BY row_id, ename, job, sal ORDER BY row_id, ename, job, sal) FROM #empl) DELETE OrderedData WHERE rn > 1SELECT * FROM #empl[/code]Wed, 20 Feb 2013 00:54:25 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1421949-392-1.aspxThis should help you out[code="sql"]; WITH cte_Delete_Dups AS( SELECT ROW_NUMBER() OVER ( PARTITION BY row_id, ename, job, sal ORDER BY row_id ) AS RN, * FROM empl)DELETEFROM cte_Delete_DupsWHERE rn > 1[/code]Wed, 20 Feb 2013 00:48:09 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1421949-392-1.aspxhai friends, i m created one table ,i wanna delete the duplicate valuescreate table empl(row_id int,ename varchar(120),job varchar(120),sal varchar(100))insert into empl ('4','ram','IT','60000')insert into empl ('4','ram','IT','60000')insert into empl ('4','ram','IT','60000')insert into empl ('4','ram','IT','60000')i am write the query to delete duplicatesdelete from empl t where t.ename>(select min(t1.ename) from empl t2 where t.job=t2.job and t.sal=t2.sal)but its was showimg error "Incorrect syntax near 't'." like dis do the need fullWed, 20 Feb 2013 00:31:19 GMTraghuldrag