How to delete the duplicate records in a table using sql
server
Answers were Sorted based on User's Feedback
Answer / mohamed idhris
SET ROWCOUNT 1
DELETE FROM tbl_name WHERE field_name= 'field_value'
SET ROWCOUNT 0
the above query will delete the duplicate row
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
What is the use of delegates
How to improve the cache performance? : Dot net architecture
What is a virtual memory? : .NET Architecture
Can I customise the trace output?
How many types of assemblies are there in the visual studio.net?
What is static Constructor?
Can you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines?
how to create applications by using Visual Studio 2012?
0 Answers TryTechnicals Pvt Ltd,
define cache memory? : Dot net architecture
What is the difference between absolute expiration and sliding-time expiration?
how to delete the record using data reader
What is the difference between l1 and l2 cache? : Dot net architecture