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 .net mobile images control. Explain with an example? : Microsoft dot net mobile
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
which is the institute in hyderabad for providing the live project industry training
What is an interrupt? : Dot net architecture
Explain different pipelining hazards and how are they eliminated? : Dot net architecture
Define cache coherency and how is it eliminated? : Dot net architecture
What is a service contract, operation contract and data contract?
What is a clickonce application?
Define cache? : Dot net architecture
Define a virtual memory? : Dot net architecture
What are the major differences between services and web services?
how to add list of items in a web application and win application?
How to improve the cache performance? : .NET Architecture
What are bindings?
What is the access level of the visibility type internal?