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
Explain the difference between HTTP and HTTPS in database?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain what is the difference between union and union all?
What happens if null values are involved in arithmetic operations?
Is ssrs support other database except ms sql server?
How to create a testing table with test data in ms sql server?
What are trace files?
What are the indexes in sql server?
What are the types of subquery?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What do you understand by SQL*Net?
what is the main function of a query parameter?
Mention what are the core components of ssrs?