delete from employee where empid in (select e.empid from employee e, em

How to delete the duplicate records from table(having bulk
records)?

Question Posted / venkat

Answer Posted / venkat

delete from employee
where
empid in (select e.empid from employee e, employee e1
where e1.empid=e.empid
group by e.empid
having count(e.empid)>1)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain How to improve the cache performance? : Dot net architecture

985

Explain .net mobile automatic paging? : Microsoft dot net mobile

983

What is .net viewstate?

981

Explain cache memory? : .NET Architecture

1026

Explain .net mobile events? : Microsoft dot net mobile

1000

What is .net mobile lists. Explain with an example? : Microsoft dot net mobile

944

Can I customise the trace output?

1129

How to improve the cache performance? : .NET Architecture

1003

What is password attribute of the textbox control of .net mobile? : Microsoft dot net mobile

975

What is the numeric attribute of the textbox control in .net mobile? : Microsoft dot net mobile

1013

Can I create my own context attributes?

1020

Define dma? : Dot net architecture

1032

Explain some of the disadvantages due to microsoft.net?

1032

What is .net mobile lists. : Microsoft dot net mobile

987

What other than biginteger has been introduced in system.numerics namespace?

1008