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

What is Video Streaming in .net??

916

What is a virtual memory? : .NET Architecture

899

i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?

2707

Explain cache memory? : Dot net architecture

892

Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile

900

Explain the difference between primary & secondary storage device? : .NET Architecture

883

Whats new features in Visual Studio 2012?

913

Explain difference between machine config vs. Web config : Dot net architecture

832

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

906

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

887

What are bindings?

927

Explain about .net garbage collector?

911

What actually happes when you add a something to arraylistcollection ?

894

What is textview control of .net mobile? : Microsoft dot net mobile

942

Differences between VS 2005, 2008 and 2010 ?

949