Re: Counting two columns with where causes for each
From: Matt Novinger <aeaas_at_yahoo.com>
Date: 17 Sep 2002 12:49:09 -0700
Message-ID: <19809582.0209171149.1fc603d1_at_posting.google.com>
Date: 17 Sep 2002 12:49:09 -0700
Message-ID: <19809582.0209171149.1fc603d1_at_posting.google.com>
Wow that worked like a charm! Thanks so much!
Matt Novinger
Applied Research Labs - Penn State
> Am I misunderstanding something here?
> Whats wrong with (assuming it's job 15 you want, not 18) ...
>
> SELECT district,
> race,
> SUM(DECODE(job,15,1,0)) jobcount,
> COUNT(date_for_raise) datecount
> FROM info
> GROUP BY district,race;
>
> CE
Received on Tue Sep 17 2002 - 21:49:09 CEST