Shorten Query
- From: Mtek <mtek@xxxxxxxxxxx>
- Date: Tue, 29 Apr 2008 09:02:27 -0700 (PDT)
Hi,
Please look at this query. notice that most of the criteria is the
same, except for 1 line. I need to get the count for 10 items. Is
there a better way to do this so I do not have to repeat the criteria
for each item I want to return?
I realize that one line of the criteria is different, but I am hoping
to not have to repeat the other criteria.....
SELECT a.q1, b.q2
FROM (SELECT count(*) q1
FROM vinst vi, vhold vh, master_table mt, stock_data sd, prices
p
WHERE vi.inst_num = vh.inst_num
AND vh.ticker = mt.ticker
AND mt.m_ticker = sd.m_ticker
AND mt.m_ticker = p.m_ticker
AND q1_shares = 0) a,
(SELECT count(*) q2
FROM vinst vi, vhold vh, master_table mt, stock_data sd, prices
p
WHERE vi.inst_num = vh.inst_num
AND vh.ticker = mt.ticker
AND mt.m_ticker = sd.m_ticker
AND mt.m_ticker = p.m_ticker
AND q0_shares = 0) b;
Thank you much,
John
.
- Follow-Ups:
- Re: Shorten Query
- From: Urs Metzger
- Re: Shorten Query
- From: Urs Metzger
- Re: Shorten Query
- Prev by Date: Right Parenthesis
- Next by Date: Re: library cache miss ratio very high - how to find out the rot cause
- Previous by thread: Right Parenthesis
- Next by thread: Re: Shorten Query
- Index(es):
Relevant Pages
|
