Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 8764 Views
- I also Faced
- E-Mail Answers
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
How can you tell if a database object is invalid?
What is subquery in sql?
What is sql injection? How to protect against sql injection attack?
What do you mean by authentication modes in sql server?
What is de-normalization and what are some of the examples of it?
What is snapshot report?
How to stop log file growing too big?
Explain mixed authentication mode of sql server?
How to create a new schema in a database?
What are the different types of sub-queries?
What is an expression in ms sql server?
What are data regions?
Explain in brief how sql server enhances scalability of the database system?
What is fill factor and pad index?
What is the difference between a "where" clause and a "having" clause?
