delete from students where badgeid not in (select max(id) from students g

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

Question Posted / mml

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

Please Help Members By Posting Answers For Below Questions

how to delete the record using data reader

2411

What happens to the winfx technologies?

942

What is Com Callable wrapper?when it will created?

888

Is dim fs as filestreamobject is a managed code? : Dot net architecture

916

Define a managed code? : Dot net architecture

885

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

901

What happens when you try to update data in a dataset in .net while the record is already deleted in sql server as backend?

928

How does .net remoting work?

1033

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

865

Define dma? : Dot net architecture

922

How do I write to the application configuration file at runtime?

933

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

833

What is the use of CLR in .NET?

968

Explain about validation?

954

Explain the purpose of cache? How is it used? : Dot net architecture

943