Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13504 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / surendra pal singh
delete from tablename where empname in (select empname from table name group by empname having empid>1)
where empname and empid are the columns of the table.
definately it will work
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define synonym?
How to move database physical files in ms sql server?
Explain what are the different index configurations a table can have?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is page-level compression?
What are the different acid properties?
what is the difference between openrowset and openquery?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How to bind a view to the schema of the underlying tables?
Can I save my report as html, excel or word? : sql server management studio
What is shrink log file?
what is blocking? : Sql server database administration
What are sql azure firewall rules?
What are trace flags?
How can you check the level of fragmentation on a table?
