Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13521 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / nittu
Delete from Tbl where Id NOT IN(
select Min(Id)
from tbl
Group By Colmn1,Column2)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you create a clustered index?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the difference between clustered and a non-clustered index?
What does ss stand for sexually?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
How do you delete a trigger?
Is INSTEAD OF trigger directly applicable to Table ?
What is the difference between Clustered and Non-Clustered Index?
What are a scheduled jobs or what is a scheduled tasks?
What are the differences between ms sql server & oracle?
Explain the types of indexes.
What are the different types of data sources in ssrs?
How to identify current user in ssrs report?
