Re: Another SQL Question

[Dave Mahadevan <mahadevan@xxxxxxxx>]

I may not have understood your question correctly.  But the following
does work.

SELECT ACCT#, COUNT(*), SUM(AMT) FROM FILEA GROUP BY ACCT#

also if you are using the entire file the group by is not required as in

SELECT COUNT(*), SUM(AMT) FROM FILEA 

QRY/400 and QM have one nice feature of getting the two selects together
by using report break function.

DAsmussen@aol.com wrote:
> 
> Hey Gang!
> 
> I tried to answer an SQL question yesterday, now I have one of my own.  Is
> there any way to incorporate the COUNT function with any other SQL
> statements?  I usually get around this by running a query with detail and
> another with COUNT.  What I need to do now is implement a GROUP BY with a
> columnar SUM function, and include the COUNT with it.  Can this be done?
>  Seems that everything I try requires using the COUNT function by itself.  As
> usual...
> 


-- 
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *