1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to delete duplicate rows in sql server2005

Question Posted / pritesh

Answer Posted / pritesh

By using temporary table, But it will delete exactly
duplicate rows NOT RECOMMANDABLE FOR HUGE TABLE. Query will
be.

SELECT DISTINCT * INTO #A FROM TABLE1

TRUNCATE TABLE TABLE1

INSERT INTO TABLE1
SELECT * FROM #A

Is This Answer Correct ?    30 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know how to implement service broker?

539

What samples and sample databases are provided by microsoft?

577

Can you explain important index characteristics?

531

Explain temporary table vs table variable by using cursor alternative?

528

What are types of scd? : sql server analysis services, ssas

540




How to create dbo table in sql server?

521

How do I view views in sql server?

522

List down some advantages of sql stored procedure?

566

Explain the working of sql privileges?

611

How to test a dml trigger in ms sql server?

583

What is meant by indexing?

509

what is nonclustered index

550

Is sql server difficult to learn?

527

Does hive support indexing?

524

What are relationships and mention different types of relationships in the dbms

563