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

Re: COUNT in SQR

begin-select
count(afield) &countfield
from ps_whatever
end-select
  show &countfield



>Date:         Fri, 12 Jun 1998 15:39:56 -0400
>Reply-To: SQR-USERS@USA.NET
>From: *Ken Chui <KChui@SMTPGW.ARMS.OHIO-STATE.EDU>
>Subject:      COUNT in SQR
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>Is it possible to declare a COUNT function on a field in BEGIN-SELECT
>and have it passed as a variable in the SHOW function?  I'm looking for
>alternatives to looping sequences to generate aggregate figures.
>
>
>- Ken
>================
>KENNETH CHUI
>OSU ARMS Project
>================
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com