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

how to change row background color in gridview

935

Explain element .net mobile with example? : Microsoft dot net mobile

919

How cache is used? : Dot net architecture

927

What is a service contract, operation contract and data contract?

879

Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile

852

Explain the difference between l1 and l2 cache? : Dot net architecture

906

question related to table havi colspan and row span

2201

What is a clickonce application?

869

What is new in the .net 2.0 class library?

1057

What is .net mobile utility controls. : Microsoft dot net mobile

918

Explain the five stages in a dlx pipeline? : Dot net architecture

878

Does .NET runtime offer Deterministic Destruction or not?

950

How can I write my own .NET host?

956

Explain how cache is used? : Dot net architecture

1022

Can I create my own permission set?

972