Use of Aggregate Functions in SQR ??

["Lempicki, Marge" <Marge.Lempicki@WL.COM>]

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