How to delete the duplicate records in a table using sql
server
Answer Posted / rakesh pattajoshi
delete from tbl where id not in(select max(id) from tbl group by name)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain 'managed' mean in the .NET context
How to improve the cache performance? : .NET Architecture
Can I create my own permission set?
What is textbox control of .net mobile? : Microsoft dot net mobile
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile
What is a virtual memory? : Dot net architecture
Explain about httpruntime.cach.get(); method?
Explain difference between machine config vs. Web config : Dot net architecture
Explain write back and write through caches? : .NET Architecture
Can you explain control extenders?
What is Object Caching in Visual Studio 2010?
What is the mesi? : Dot net architecture
Explain difference between inprocess vs out process session state? : .NET Architecture
what is tracing? Where it used?