Answer / mon

DELETE FROM MyTable
LEFT OUTER JOIN (
SELECT MIN(RowId) as RowId, Col1, Col2, Col3
FROM MyTable
GROUP BY Col1, Col2, Col3
) as KeepRows ON
MyTable.RowId = KeepRows.RowId
WHERE
KeepRows.RowId IS NULL

Answer / arun kumar k s

drop table #TEMP select distinct * into #TEMP from
TABLE_NAME delete from TABLE_NAME insert into TABLE_NAME
select * from #TEMP

Answer / gaurav jain

begin
select distinct * into #one from four where id in (select
id from four group by id
having count(*)>1)
delete from four where id in (select id from four group by
id having count(*)>1)
insert into four select * from #one
end

Answer / anoop rajan

Tbale emp had some duplicate entries and i wanted to retain
the first of all duplicates, the others could be deleted as
follows . Please give your comments if this is the most
optimum way :

delete from emp where rowid in
(select rowid from emp o where rowid !=
(select min(rowid) from emp i where i.empno=o.empno));

Answer / pawan k. dubey

delete from employee
where Emp_id not in (select min(Emp_id) from employee
group by Emp_Name)

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

what is differece between union and union all

6 Answers  

How to assign null values to variables or columns?

0 Answers  

What is a trigger? Why we need it?

0 Answers   Accenture,

What is difference between createstatement and preparedstatement?

0 Answers  

What is a cursor in SQL Server 2000 and their types?

8 Answers  

How to loop through the result set with @@fetch_status?

0 Answers  

How to sort query output in descending order in ms sql server?

0 Answers  

What is an inner join?

0 Answers  

List down some advantages of sql stored procedure?

0 Answers  

Is there any difference between primary key and unique with the not null condition?

0 Answers  

What is the difference between sdf and mdf?

0 Answers