how to delete duplicate rows in sql server2005
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
Explain can you implement data mining in ssrs?
Explain what is meant by replication of database?
What is a non equi join?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to define output parameters in stored procedures?
What is exporting and importing utility?
Can you explain what are various ways to enhance the ssrs report?
Can you tell me about the concept of ER diagrams?
How to replace given values with null using nullif()?
What is the difference between varchar and nvarchar?
Can multiple columns be used in sql group by clause in ms sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Why I have to use stored procedures?
do you know how to configure db2 side of the application? : Sql server database administration
How to count groups returned with the group by clause in ms sql server?