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
What is msil, and why should my developers need an appreciation of it if at all?
Explain the Lapsed Listener problem in .net
8. Oop-Why and were we use Interfacse and Abstract class.
what are constructors and destructors?
What is an asssembly qualified name? Is it a filename? How is it different?
Tell me .net mobile emulators? : Microsoft dot net mobile
Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile
Define cache? : Dot net architecture
Define dma? : Dot net architecture
Explain the difference between primary & secondary storage device? : Dot net architecture
What is one way operation?
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile
What is private constructor? And it's use?
Define cache coherency? : Dot net architecture
Explain the difference between primary & secondary storage device? : .NET Architecture