Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from table in sql server
- 12 Answers
- 22700 Views
- HCL, UHG, I also Faced
- E-Mail Answers
Answer Posted / vignesh chandrasekaran
select Distinct column name from Table Name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are types of scd? : sql server analysis services, ssas
what are user defined datatypes and when you should go for them? : Sql server database administration
How do I view a procedure in sql server?
Explain how does the report manager work in ssrs?
what kind of lan types do you know? : Sql server database administration
How to test values returned by a subquery with the in operator?
what is the difference between delete table and truncate table commands? : Sql server database administration
How to delete duplicate rows from table except one?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is difference between delete and truncate commands?
What are key constraints?
What is log ldf?
What are the 3 types of schema?
What is normalization and its types?
How many databases instances are there in sql server 2000?
