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
- 8951 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 to find tables without indexes?
Can you explain the disadvantages/limitation of the cursor?
What is the sql profiler?
Explain tables in SQL Azure?
What is query processing?
What is analysis service repository?
What is a transact-sql statement batch in ms sql server?
What samples and sample databases are provided by microsoft?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How to execute multiple stored procedures at one time in sql server?
How can you insert null values in a column while inserting the data?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is a raid and what are different types of raid configurations?
Give me any three differences between Truncate and Delete.
What is single-user mode?
