query rewrite [message #643058] |
Sun, 27 September 2015 18:22 |
|
gidiyap
Messages: 2 Registered: September 2015
|
Junior Member |
|
|
i have a query below but i'm having difficulties in rewriting it. any other approach you have in mind?
delete from
table1 a, table2 b
where
a.col1 =b.col1
a.col2 = b.col2
a.col3 < b.col3
if the last filter condition does not exist , i can easily use the approach below, however, that last filter is a roadblock to me..
delete from
table1
where (col1, col2, col3) in ( select b.col1, b.col2, b.col3 from table2 b)
|
|
|
|
|
|
Re: query rewrite [message #643068 is a reply to message #643058] |
Mon, 28 September 2015 04:59 |
|
sandeep_orafaq
Messages: 88 Registered: September 2014
|
Member |
|
|
May be you can try exists clause.
Something like
delete from table1
where exists (select null
from table2
where table1.col1 = table2.col1
and table1.col2 = table2.col2
and table1.col3 < table2.col3);
|
|
|