DELETE FROM school WHERE badgeid NOT IN(SELECT MAX (badgeid) FROM school

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

Question Posted / asha

Answer Posted / asha

DELETE FROM school WHERE badgeid NOT IN(SELECT MAX
(badgeid) FROM school GROUP BY id);

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I know when my thread pool work item has completed?

918

When do I need to use gc.keepalive?

1065

.Net Frame work arch?

2044

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

1936

Explain about code access security?

993

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

1028

Does application frame need host?

938

What is a clickonce application?

928

Tell me .net mobile emulators? : Microsoft dot net mobile

948

How do I prevent concurrent access to my data?

1029

Explain about .net garbage collector?

944

How can implement drag and drop using atlas?

1005

Explain 'managed' mean in the .NET context

1118

12. Types of polymorphisem[Run and Design Exp.]

2065

Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile

1026