| seema |
Posted: Apr 17, 2008 01:26:38 AM |
Total Post: 62
Joined: Jan, 2008
|
| How to delete duplicate records from one table. |
|
|
 GOPU |
| Posted: Apr 17, 2008 01:55:22 AM |  |
|
Total Post: 333
Joined: Apr, 2008
|
DELETE FROM duptest WHERE rowid NOT IN (SELECT max(rowid) FROM duptest GROUP BY id);
|
|
|
|
|
| Murtuja |
| Posted: Apr 17, 2008 02:09:45 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
http://www.google.com/search?hl=en&q=+delete+duplicate+records+oracle&meta=
|
|
|
|
|
| GOPU |
| Posted: Apr 17, 2008 02:13:17 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
DELETE FROM
table_name A
WHERE
a.rowid >
ANY (
SELECT
B.rowid
FROM
table_name B
WHERE
A.col1 = B.col1
AND
A.col2 = B.col2
);
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 17, 2008 02:48:18 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
http://dbataj.blogspot.com/2007/06/delete-duplicate-rows.html
|
|
|
|
|
| nag |
| Posted: Apr 21, 2008 02:23:37 AM | |
|
Total Post: 4
Joined: Apr, 2008
|
select * from emp1 ep1
where rowid<(select max(rowid) from emp1 ep2
where ep1.empno=ep2.empno)
|
|
|
|
|
| seema |
| Posted: Sep 02, 2008 06:09:46 AM | |
|
Total Post: 62
Joined: Jan, 2008
|
Tell me one more thing how to delete a particular record from duplicate records.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
