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

Tell me what is difference between view and materialized view?

528

Can I save my report as html, excel or word? : sql server management studio

550

How to rebuild master databse?

673

What happens if date-only values are provided as date and time literals?

549

What authentication modes does sql server support?

599

Explain what are the authentication modes in sql server?

504

Do you know sql server 2008 introduces automatic auditing?

520

How do we Backup SQL Azure Data?

How do triggers work?

544

What is transaction server distributed transaction?

565

Explain different types of self contained sub query?

546

What are the database objects? : SQL Server Architecture

555

Why Master database is required?

607

What is a document index?

593

What is cached report?

106