[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Manipulating Aggregate Function Values

                -----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

                Thank you

                Marc Bergeron



                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
<mailto: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 <http://mail.yahoo.com>