using cursor is another option

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / ghous

Answer Posted / ghous

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How many joins in sql server?

935

what are the different stages of Report Processing?

135

When we should use @@error?

958

What is rtm version in sql server?

1035

What is sql server locking?

975

List out different types of normalizations in sql server and explain each of them?

916

How to get a list of all tables with "sys.tables" view in ms sql server?

1027

How to change the system date and time from SQL Plus Terminal ?

1210

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1052

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

908

What are the disadvantages of primary key and foreign key in SQL?

1101

Explain relational data?

906

Difference between Inner vs outer joins?

939

What is difference between oltp and olap?

1032

What is indexed view? How to create it?

978