Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24999 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
In sqlserver 2000 we must use a unique id per row then we
can delete duplicate rows.
delete from <tablename> where <rowid> not in (select min
(<rowid> from <tablename> group by co1,col2.)
But in sqlserver 2005 there a function RowId.Which is same
as above concept.It return unique id per row.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to find the login name linked to a given user name?
What are the system database in sql server 2005?
Can you explain about buffer cash and log cache in sql server?
what is package and it uses and how can u call a package
Explain transaction server consistency?
What is BLOCK statements in SQL?
What is scrollable cursor?
Explain log shipping?
Can we create clustered index on composite key?
What is Federation and Federation Member?
What is recompile sql server?
What are scalar functions in sql?
how can u get last observation in an unknown dataset ?
what changed between the previous version of sql server and the current version? : Sql server database administration
How exceptions can be handled in sql server programming?
