Re: Another SQL Question

["Mike Kenney" <kenney@xxxxxxxxxxxxxxxxx>]

This may or may not answer your question.  
 SELECT FIELD1,SUM(AMOUNT1),COUNT(*)  from FILEA GROUP BY FIELD1  
 HAVING COUNT(*) > 3   

I appologize if I am missing your question. I have run into instances 
where a single query wouldn't do the  job and I had perform multiple 
steps were required to get results.   

> 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...
> 
Michael Kenney 
Computing Services
University of Windsor  
Windsor, Ontario 
Canada
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *