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

Answer Posted / ghous

using cursor is another option

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is create statement?

520


What is indexing in sql server with example?

510


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

527


What is the difference between a function and a trigger?

561


What are the results of running this script?

501






What is normalization and what are the advantages of it?

508


How to remove duplicate rows from table?

585


How to convert a table data in XML format in sql server?

2108


Explain intellisense for query editing

556


How to drop existing views from a database in ms sql server?

519


Do you know what are different types of replication in sql server?

501


How can windows applications connect to sql servers via odbc?

569


What are database states in ms sql server?

644


What is rank function?

597


Do you know what are acid properties of transaction?

516