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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I stop a thread?

535


Explain different pipelining hazards? : Dot net architecture

470


Session State and can i store desirialized object in state server, if yes how and if not why.

1345


Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.

517


Explain hard disk and what is its purpose? : Dot net architecture

509






What is an asssembly qualified name? Is it a filename? How is it different?

508


Explain hard disk? : Dot net architecture

572


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

519


Can I create my own permission set?

528


question related to table havi colspan and row span

1788


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

562


Explain dma? : Dot net architecture

553


Does .NET runtime offer Deterministic Destruction or not?

594


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

1434


What are the types of memory management? : Dot net architecture

486