if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 duplicate and 1 original as it is,how?
Answer Posted / siva raman
By using Rank function we can delete duplicate records in
tables.
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is the difference between TRUNCATE and DROP?
How to read data in a table with "select" statements?
What is service broker? : sql server database administration
What is auditing in sql server?
what is datawarehouse?
What is the synonym of join?
How to maintain a fill factor in existing indexes?
Do you know what are different types of replication in sql server?
explain different types of joins? : Sql server database administration
What is the correct order of the logical query processing phases?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to use old values to define new values in update statements in ms sql server?
Explain how many types of relationship?
What is temporary table in sql server? Why we use temp table?