|
| Total Answers and Comments: 4 |
Last Update: November 19, 2007 Asked by: ravis |
|
| | |
|
No best answer available. Please pick the good answer available or submit your answer. | |
June 23, 2006 05:56:12 | #2 |
| Atanu Basu |
|
|
RE: how to find out duplicate records ?
| LET THINK EMP IS A TABLE AND EMP_CODE IS THE KEY ATTRIBUTE SELECT * FROM EMP WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM EMP GROUP BY EMP_CODE) |  | | Is this answer useful? Yes | No | | |
|
| |
Go To Top
|