Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed for select query
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