Re: Help needed for select query

<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

 sum(decode(trunc(time),trunc(sysdate),1,0) "Yesterday" , sum(decode(trunc(time),trunc(sysdate),0,1) "Last week"

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 26 2001 - 08:26:51 CDT