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

What is the cli? Is it the same as the clr?

954

When do I need to use gc.keepalive?

1069

What's the difference between an application and a program?

1136

Explain Singleton design pattern in .net

989

What are the different pipelining hazards and how are they eliminated? : Dot net architecture

1033

What is the problem with .net generics?

1074

Which software is used for .net programming?

937

Can I create my own permission set?

1044

Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

929

What is cookie less session?

1017

What is one way operation?

969

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

931

What does the term "green architecture" mean? : .NET Architecture

969

difference between data reader and dataset

2236

Explain pipelining? : Dot net architecture

1001