Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13689 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
What is sql server query analyzer?
Explain something about security and SQL Azure?
What is Sqlpaging in SqlServer 2005 ?
Write an sql query for deleting duplicate rows?
How to change server name in sql server?
Can a rule be bound to any column of any data type?
Explain sql server authentication modes?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
what's new in sql server 2016?
Does partitioning help performance?
What is molap and its advantage? : sql server analysis services, ssas
What is the difference between executequery () and executeupdate ()?
What is exporting utility?
What is a collation?
