delete tmp from(select col1,col2,row_number over(partition by col1,col2 o

write a query to remove duplicate records without using primary key column?

Question Posted / mathanrathinam

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

Please Help Members By Posting Answers For Below Questions

Explain error and transaction handling in sql server?

1018

Explain error handling in ssis?

1034

Mention the differences between local and global temporary tables.

1049

If the job running very slow what is the action you do

1897

What is sql sandbox in sql server?

1236

Explain the third normal form(3nf)?

950

What is an etl file?

958

Can you create a logon trigger in sql server 2005 express edition?

1085

What is query processing?

942

Can you index views?

898

What happens if null values are involved in boolean operations?

987

How to delete duplicate records based on single column from a table?

1056

Explain what stored procedure sp_replcounters is used for? : sql server replication

1525

What is normalization of database? What are its benefits?

1029

What is sharding?

116