How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
Answer Posted / anil kumar karasi
1.
Select from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);
2.
Delete from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);
Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
What is the latest version of microsoft sql server?
What is user-defined inline table-valued function?
How to link tables in sql server?
how to use DTS package in 2000,2005,2008 in sql server
Explain about unique identifier data type in sql server?
How to add a new dsn with the odbc driver for sql server?
How except clause is differs from not in clause?
What is linked report?
Explain few examples of RDBMS?
Does hive support indexing?
Why use triggers?
Explain datetime2 data type in sal server 2008?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is stored procedures?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?