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

Explain cache? : .NET Architecture

1064

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

985

Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile

958

difference between Response.write,server.transfer and also which one is used when ?

1958

What actually happes when you add a something to arraylistcollection ?

991

Explain the difference between inprocess vs out process session state : Dot net architecture

1154

Is .net easier than java?

978

Explain How to improve the cache performance? : Dot net architecture

984

What is code access security (cas)?

1079

Explain .net mobile selectionlist control? : Microsoft dot net mobile

1025

I want to create a project like google maps how can we do that with atlas?

998

Define dma? : Dot net architecture

1032

how to set the startup position of the form?

2002

Explain hard disk? : Dot net architecture

1043

Can you explain atlasuiglitz library?

980