On Sep 10, 2004, at 12:39 PM, blackwater dev wrote:


I need to grab the max value of all of the data in a table grabbing
the max total for each client.  Example.

id        total      clientid
1          100           111
2          200           111
3          100           112
4          150           112

I need a query that will grab the highest total per clientid (200, and
150) then average them.  My first inclination is to do a subselect

select avg(total) from t1 where max(total) from t1 t2
where t2.clientid=t1.clientid)

But can't use subselects with do I do it??

Yes you can. Check this out and see if all your syntax is correct.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to