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 are the important principles of soa (service oriented architecture)?

934

how can we achieve language interoperability through CLS? How MSIL works?

1090

Use of Enable view state ? if turn off what happen ?

4493

Explain pipelining? : Dot net architecture

1007

Explain about code access security?

1004

Explain about appdomains?

1038

Explain cache? : .NET Architecture

1009

Explain about microsoft visual studio?

984

What is Opf3

1010

Explain dma? : .NET Architecture

958

How to improve the cache performance? : Dot net architecture

938

Difference between throw exception and rethrowing ?

2125

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

930

what is the method while we are using adapter and dataset ?

1871

Which software is used for .net programming?

945