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
- 8790 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
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is 2nf example?
How use inner join in sql server?
What is inline table-value user-defined function?
How to make remote connection in database?
What according to you is the difference between mysql and sql server performance?
What happens if time-only values are provided as date and time literals?
What is the difference between char and varchar2 datatype in sql?
What are the different authentication modes in sql server? How can it be changed?
can SSRS reports Cache results?
Does sql server use t sql?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is similarity and difference between truncate and delete in sql?
How to delete all rows with truncate table statement in ms sql server?
How to make conditional sum in ssrs?
