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

Re: Use of Aggregate Functions in SQR ??

Marge,

Yep.  Just try it.

begin-select
emplid &empl_id
max(end_balance) &max_end_balance
   do something
from ps_pa_accums
where functn_result_nm = 'aaaaaa_b'
group by emplid
end-select

Ray

> Can SQL aggregate functions be used in SQR ? I would like to be able to get
> the same functionality as the following SQL Statement.
>
> Select  emplid,  max(end_balance)
>   From ps_pa_accums
>    Where  functn_result_nm = 'aaaaaa_b'
>     Group by emplid
>
> Thanks,
>
> Marge
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/