Re: Manipulating Aggregate Function Values

["Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG>]

Thank you very much, Marc

                -----Original Message-----
                From:   Les Hancock [mailto:les_hanc@YAHOO.COM]
                Sent:   Tuesday, August 25, 1998 4:53 PM
                To:     Multiple recipients of list SQR-USERS
                Subject:        Re: Manipulating Aggregate Function
Values

                One possibility:

                begin-select
                count(*)  &count_ees
                  let #count = &count_ees * -1
                  print #count (+1,1)
                from ps_employees
                end-select


                ****************************************




                ---"Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG> wrote:
                >
                > It's great to be able to use Aggregate functions (MAX,
SUM,
                > COUNT(*).....) in SQR but how does one multiply the
resulting SUM() by
                > -1 or PRINT COUNT(*).
                >


_________________________________________________________
                DO YOU YAHOO!?
                Get your free @yahoo.com address at
http://mail.yahoo.com