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
- 8549 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
Can a table have 2 primary keys?
Describe the left outer join & right outer join. : sql server database administration
What is sql server management studio? : sql server management studio
What the different types of Replication and why are they used?
How do I find the sql server database version?
What are the components of sql server service broker?
What is tablesample?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to download and install microsoft sql server management studio express?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is implicit mode in sql server?
How can I know what locks are running on which resource?
What are group functions in query statements in ms sql server?
How to integrate the ssrs reports in application?
