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

Is oracle faster than sql server?

741


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

807


What are the events recorded in a transaction log?

772


Does a sql server 2005 select statement require a from?

814


How to use transact-sql statements to access the database engine?

788


Why and when do stored procedure recompile?

747


What is a select query statement in ms sql server?

802


What is the stored procedure?

786


Can foreign key be deleted?

709


Explain the disadvantages of cursors?

797


What is built-in/administrator?

772


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

773


what are the different types of replication you can set up in sql server? : Sql server database administration

783


How do I find the sql server database version?

723


How does using a separate hard drive for several database objects improves performance right away?

736