Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Problem

Re: SQL Problem

From: <dbawon_at_yahoo.com>
Date: 9 Jan 2005 20:46:50 -0800
Message-ID: <1105332410.705623.136670@c13g2000cwb.googlegroups.com>


This may not perform as well as desired.

select *
from ledger_t A
where Tx_typ = 4
and exists ( select 1
from ledger_t B
where Tx_typ = 92
and A.cid = B.cid
and A.lid > B.lid
and exists ( select 1
from ledger_t C
where Tx_typ = 24
and B.cid = C.cid
and B.lid > C.lid )); Received on Sun Jan 09 2005 - 22:46:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US