Re: Help needed for select query

This might solve your problem.

SELECT source,
select count(decode( time, sysdate-1, 1, 0)) "yesterday", COUNT(*) "Last week"
FROM event
WHERE time > TRUNC(SYSDATE-7)
GROUP BY source
ORDER BY COUNT(*) DESC, source

<library.treasures_at_NOSPAMsaqnet.co.uk> wrote in message news:3bd95661.15061363_at_news.easynet.co.uk...
> I have an event table with a source column and a time colum.
>
> I need to count and sort in descending order the number of events per
> source.
>
> I can count one day's totals and the last week's totals by two
> separate scripts:
>
> SELECT source, COUNT(*) "Yesterday"
> FROM event
> WHERE time > TRUNC(SYSDATE-1)
> GROUP BY source
> ORDER BY COUNT(*) DESC, source;
>
> SELECT source, COUNT(*) "Last week"
> FROM event
> WHERE time > TRUNC(SYSDATE-7)
> GROUP BY source
> ORDER BY COUNT(*) DESC, source;
>
>
> However, I would like to unify these two separate queries in a single
> query because I want the two column, "Yesterday" and "Last week", to
> appear side by side.
>
> How is it possible to achieve this?
>
> Thanks for any help in advance.
>
> Thomas
Received on Fri Oct 26 2001 - 10:43:07 CDT