write a query to remove duplicate records without using primary key column?
Answer Posted / mathanrathinam
delete tmp from(select col1,col2,row_number over(partition by col1,col2 order by col1,col2) rownum from tablename) tmp
where rownum >1
Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What will be the maximum number of index per table?
How to make a remote connection in a database?
What are the different types of collation sensitivity?
Is it possible in sql table to have more than one foreign key?
How to disable a login name in ms sql server?
What is the use of group by clause?
How to execute a sql statement using odbc_exec()?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Can you import Microsoft Excel data to SSRS?
What are the recovery models for a database?
How does recursive cte works in sql server?
Please explain go command in sql server?
System variable and temporary variables
can a database be shrunk with users active? : Sql server administration