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 similarity and difference between truncate and delete in sql?

1086

How can we determine what objects a user-defined function depends upon?

991

What is an etl file?

949

What is standby servers? Explain types of standby servers.

988

What is meant by Active-Passive and Active-Active clustering setup?

1161

Explain what is the function of sql server agent windows service?

986

How to set a database state to offline in ms sql server?

1036

What is self contained scalar sub query?

970

What is the command to change the recovery model?

1037

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1040

How to replace the Query Result 'Null Value' with a text ?

1025

How to transfer data from a cursor to variables with a "fetch" statement?

1082

Explain foreign key in sql server?

1012

What are scalar functions in sql?

1135

Explain about link server in sql server?

1048