Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13684 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
Can a database be shrunk with users active?
What are the options which must be set to allow the usage of optimistic models?
Is sql different from sql server?
Do you know nested transaction?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to use clusters?
Define msdb database?
What is cte (common table expression)?
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to remove duplicate rows from table except one?
what are the different types of SSRS reports?
What are the types of sql server?
What is built-in/administrator?
List some of the rules that apply to creating and using a ‘view’
What are the differences between DDL, DML and DCL in SQL?
