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 write back and write through caches? : .NET Architecture

893

What are the important principles of soa (service oriented architecture)?

921

Explain domestic architecture artifacts? : Dot net architecture

904

Explain about appdomains?

1025

difference between Response.write,server.transfer and also which one is used when ?

1914

What is the mesi? : Dot net architecture

1023

Explain pipelining? : .NET Architecture

951

4. Wcf- what Asych and Sych call and how that works

1933

Explain COM with example?

941

.Net Frame work arch?

2041

What are relation objects in dataset?

977

how to use custom field validation

2475

Define a virtual memory? : Dot net architecture

906

What re interop services?

1003

how to set the startup position of the form?

1930