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)

Write a sql query to delete duplicate records from a table called table1

0 Answers  

What is a fill factor?

0 Answers  

List the types of recovery model available in sql server?

0 Answers  

If there is failure during updation of certain rows, what will be the state?

2 Answers  

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

What does man by sql wildcard characters in sql server?

0 Answers  

What is field in algebra?

0 Answers  

How much is a sql server license?

0 Answers  

How to compare the top two records using sql?

0 Answers  

What is relationship? What number of sorts of relationship are there?

0 Answers  

What does ss stand for sexually?

0 Answers  

What is the full form of dql?

0 Answers