[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

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