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

What is a dbms wizard?

973

How to stop log file growing too big?

962

Benefits of Stored Procedures?

933

Explain what are the basic functions for master, msdb, model, tempdb databases?

919

Explain what are various ways to enhance the ssrs report?

1000

What happens if you add a new index to large table?

894

What is the difference between varchar and nvarchar datatypes?

1043

State the difference between local and global temporary tables?

1056

What are the database objects? : SQL Server Architecture

994

What is sql language?

1043

What are the types of database recovery models?

1062

What is data source object?

957

what are the Prerequisites for Replication?

11253

Which sql server table is used to hold the stored procedure scripts?

1034

Explain what are magic tables in sql server?

951