Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13237 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
Explain the disadvantages/limitation of the cursor?
What is the purpose of a table?
Explain having clause?
Are all views updatable ?
What is collation sensitivity? Explain different types.
What does asynchronous call backs means?
Does an index slow down updates on indexed columns?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are the limitations in ssrs on sql server express edition?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the name of the Database which IBM mainframe uses?
What is the difference between char, varchar and nvarchar?
How to loop through returning rows?
What samples and sample databases are provided by microsoft?
Explain different forms of normalization?
