how to delete duplicate rows in sql server2005
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
Does group by or order by come first?
What is the contrast between sql and pl/sql?
How to access the inserted record of an event?
List out different types of normalizations in sql server and explain each of them?
What is the maximum number of index per table?
What is the use of builtinadministrators group in sql server? : sql server security
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Data table as parameter in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What are the dmvs?
Explain can SSRS reports Cache results?
Describe how to use linked server?
what is a transaction? : Sql server database administration
Explain transaction server distributed transaction?