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 the use of virtual, sealed, override, and abstract.

564

Explain COM with example?

562

What is the difference between an application and a program?

488

Explain about metadata?

520

What is the cli? Is it the same as the clr?

510

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

459

What re interop services?

557

How can I create a application?

510

How cache is used? : Dot net architecture

495

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

510

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

547

What are end points, contract, address and bindings?

521

Explain how does .net mobile work? : Microsoft dot net mobile

495

i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?

2306

hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays

1881