Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query help
Try
SQL> select sa_states.state, sa_states.area,
sum(decode(sa_stat.prec,'Snow',1,0)) snow
2 from sa_states, sa_stat
3 where sa_states.state=sa_stat.state(+)
4 group by sa_states.area, sa_states.state;
:0)
Anurag
Pete wrote in message ...
*****snip********
>
>Thanks alot for taking a look at this.
>Pete
>
>
>Current Query
>SQL> select sa_states.state, sa_states.area, nvl(count(sa_stat.prec),0)
>as snow
> 2 from sa_states, sa_stat
> 3 where sa_states.state=sa_stat.state(+)
> 4 and nvl(sa_stat.prec, 'Snow')='Snow'
> 5 group by sa_states.area, sa_states.state;
>
>STATE AREA SNOW
>-------------------- -------------------- ---------
>CO West 0
>GA South 1
>IN North 2
>NY North 0
>TX South 1
>
>
>
Received on Wed Mar 03 1999 - 01:01:49 CST