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

What is store procedure? How do they work? When do you use?

885

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1113

What is subquery? Explain the properties of a subquery?

924

What is the difference between value type and reference type?

863

Give the query of getting last two records from the table in SQL SERVER?

899

What does Master database contains?

1080

If no size is defined while creating the database, what size will the database have?

918

How to delete database objects with "drop" statements in ms sql server?

1030

Define clusters?

993

How will you add a dimension to cube? : sql server analysis services, ssas

1012

Differentiate between a primary key and a unique key.

998

Explain comment on transactions?

932

What is xml datatype?

1028

Differentiate between mongodb vs. Sql server?

1028

How to create a testing table with test data in ms sql server?

1011