 |
|
07-11-2009, 01:08 PM
|
#1 (permalink) | ||||||||||||||
|
Join Date: Jul 2009
Posts: 10
Thanks: 1
Thanked 2 x in 2 Posts
|
Help in Query
Hello How to delete the duplicate row in oracle. Thanks Lego Instructions |
||||||||||||||
|
|
||||||||||||||
|
12-03-2009, 05:07 PM
|
#2 (permalink) | ||||||||||||||
|
Join Date: Dec 2009
Posts: 10
Thanks: 0
Thanked 0 x in 0 Posts
|
Re: Help in Query
DELETE FROM tbl A WHERE A.rowid > ANY (SELECT B.rowid FROM tbl B WHERE A.col1 = B.col1 AND A.col2 = B.col2 .....); Lego Instructions |
||||||||||||||
|
|
|
||||||||||||||
Linear Mode
