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


Please Help Members By Posting Answers For Below Questions

What is the difference between TRUNCATE and DROP?

871


How to read data in a table with "select" statements?

782


What is service broker? : sql server database administration

805


What is auditing in sql server?

734


what is datawarehouse?

901


What is the synonym of join?

743


How to maintain a fill factor in existing indexes?

791


Do you know what are different types of replication in sql server?

802


explain different types of joins? : Sql server database administration

777


What is the correct order of the logical query processing phases?

742


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

917


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

839


How to use old values to define new values in update statements in ms sql server?

948


Explain how many types of relationship?

815


What is temporary table in sql server? Why we use temp table?

762