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
Is oracle faster than sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What are the events recorded in a transaction log?
Does a sql server 2005 select statement require a from?
How to use transact-sql statements to access the database engine?
Why and when do stored procedure recompile?
What is a select query statement in ms sql server?
What is the stored procedure?
Can foreign key be deleted?
Explain the disadvantages of cursors?
What is built-in/administrator?
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?
what are the different types of replication you can set up in sql server? : Sql server database administration
How do I find the sql server database version?
How does using a separate hard drive for several database objects improves performance right away?