write a query to remove duplicate records without using primary key column?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is difference between views and tables?
what is performance tunning in sql server ? explain.
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......
How to remove duplicate rows from table?
Questions regarding Raiseerror?
What is database architecture? : SQL Server Architecture
How to Generate a Series of Random Integers With T-SQL?
How to make a column nullable?
What is a Join in SQL Server?
What are locks in sql?