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

Answer Posted / mml

delete from students where badgeid not in (select max(id)
from students group by badgeid);

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is WPF and WCF?

573


What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture

663


Is .net easier than java?

524


Explain the five stages in a dlx pipeline? : Dot net architecture

490


What are relation objects in dataset?

547






What are the major differences between services and web services?

495


What is the purpose of Accordian in jquery? Where it can be used?

1862


Explain write back and write through caches? : .NET Architecture

518


How can we integrate atlas with web services?

523


Explain dma? : Dot net architecture

562


Explain about appdomains?

609


deference between display and visibility property of CSS

1789


Explain the use of virtual, sealed, override, and abstract.

572


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

487


What is Com Callable wrapper?when it will created?

533