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 the use of virtual, sealed, override, and abstract.

936

Define dma? : Dot net architecture

936

how to change row background color in gridview

959

What are bindings?

947

readonly syntax ?

1826

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

934

What are the main Tools to develop .Net Application?

913

Explain about common language infrastructure?

914

What is cache coherency and how is it eliminated? : .NET Architecture

971

Explain write back and write through caches? : .NET Architecture

870

What is code access security (cas)?

977

What are relation objects in dataset?

946

Define a virtual memory? : Dot net architecture

877

Explain the types of memory management? : Dot net architecture

914

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

839