How to delete the duplicate records from table(having bulk
records)?
Answer Posted / asha
DELETE FROM school WHERE badgeid NOT IN(SELECT MAX
(badgeid) FROM school GROUP BY id);
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How do I stop a thread?
Explain different pipelining hazards? : Dot net architecture
Session State and can i store desirialized object in state server, if yes how and if not why.
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
Explain hard disk and what is its purpose? : Dot net architecture
What is an asssembly qualified name? Is it a filename? How is it different?
Explain hard disk? : Dot net architecture
What is the difference between l1 and l2 cache? : Dot net architecture
Can I create my own permission set?
question related to table havi colspan and row span
What's the difference between an application and a program?
Explain dma? : Dot net architecture
Does .NET runtime offer Deterministic Destruction or not?
4. Wcf- what Asych and Sych call and how that works
What are the types of memory management? : Dot net architecture