RE: Syntax of case statement using a count function

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Tried that, it didn't work

> -----Original Message-----
> From: Peter Dow [SMTP:pcdow@yahoo.com]
> Sent: Tuesday, September 04, 2001 2:17 PM
> To:   midrange-l@midrange.com
> Subject:      Re: Syntax of case statement using a count function
>
> Hi Bill,
>
> How about just changing your example a little? Instead of sales, use 1:
>
>  Select fielda, fieldb,
>   sum(case when "MONTH" = 1 then 1 else 0 end)
>   sum(case when "MONTH" = 2 then 1 else 0 end)
>   .
>   .
>   .
>  From Filez
>  Group by fielda, fieldb
>
> hth,
> Peter Dow
> Dow Software Services, Inc.
> 909 425-0194 voice
> 909 425-0196 fax
>
> From: "Bill Erhardt" <ERHARDT@BaldwinHQ.com>
> > Thank you for your response but I know how to use the count(*) function.
> > What I'm trying to do is use the count function in a case statement like
> I'm
> > using the sum function below:
> >
> > Select fielda, fieldb,
> >  sum(case when "MONTH" = 1 then sales else 0 end)
> >  sum(case when "MONTH" = 2 then sales else 0 end)
> >  .
> >  .
> >  .
> > From Filez
> > Group by fielda, fieldb
> >
> >
> > > -----Original Message-----
> > > From: bill.reger@convergys.com [SMTP:bill.reger@convergys.com]
> > > Sent: Tuesday, September 04, 2001 11:29 AM
> > > To: midrange-l@midrange.com
> > > Subject: Re: Syntax of case statement using a count function
> > >
> > >
> > > SELECT COUNT(*) FROM library/file  WHERE FLDNAM       =   500
> > --
> >
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
--