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

What is application frame host?

1078

Explain the types of memory management? : .NET Architecture

932

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

4474

What is new in the .net 2.0 class library?

1107

Explain dma? : Dot net architecture

1009

How can I write my own .NET host?

1009

Define an interrupt? : Dot net architecture

975

Whats new features in Visual Studio 2012?

969

What is .net mobile utility controls. Explain with an example? : Microsoft dot net mobile

873

What is the importance of updatepanel control?

1055

What is a service class?

1003

Differnce between managed code and unmanaged code ?

1070

What is a clickonce application?

928

What are different types that a variable can be defined and their scopes ?

1049

How resource files are used in .net?

1029