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 Video Streaming in .net??
What is a virtual memory? : .NET Architecture
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
Explain cache memory? : Dot net architecture
Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile
Explain the difference between primary & secondary storage device? : .NET Architecture
Whats new features in Visual Studio 2012?
Explain difference between machine config vs. Web config : Dot net architecture
Explain the difference between l1 and l2 cache? : Dot net architecture
Can you Explain
What are bindings?
Explain about .net garbage collector?
What actually happes when you add a something to arraylistcollection ?
What is textview control of .net mobile? : Microsoft dot net mobile
Differences between VS 2005, 2008 and 2010 ?