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: Help needed for select query

Re: Help needed for select query

From: andrija <ar35644_at_fer.hr>
Date: Fri, 26 Oct 2001 15:16:27 +0200
Message-ID: <9rbnml$6dnc$1@as201.hinet.hr>


Try something like this:

select A.source, A."Yesterday",B."Last week" from
(SELECT source, COUNT(*) as "Yesterday"

FROM event
WHERE time > TRUNC(SYSDATE-1)
GROUP BY source
ORDER BY COUNT(*) DESC, source) A,
(SELECT source, COUNT(*) "Last week"

FROM event
WHERE time > TRUNC(SYSDATE-7)
GROUP BY source
ORDER BY COUNT(*) DESC, source) B
where A.source=B.source
order by 2 desc,1 Received on Fri Oct 26 2001 - 08:16:27 CDT

Original text of this message

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