Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13493 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
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
What is cdc in sql server?
What is the stuff?
What is merge replication?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to execute a sql statement using mssql_query()?
Explain tables in SQL Azure?
What are page splits? : SQL Server Architecture
Name the different type of indexes in sql?
How can you find out how many rows returned in a cursor?
What are examples of triggers?
How do you identify a foreign key?
What is row-level compre?
What does COMMIT command do?
What are different types of schemas?
What are 3 ways to get a count of the number of records in a table?
