[thelist] SQL Help

Joshua Olson joshua at waetech.com
Fri Feb 13 23:26:17 CST 2004

> -----Original Message-----
> From: David Mitchell
> Sent: Friday, February 13, 2004 11:47 AM
> I have a table where each row is a budget entry. There is a column
> called "notifications" which is an int, and is between 0 and 6. I have
> to sum the money values for rows based on certain criteria, BUT I can
> only sum rows of the highest notification number. I tried something like:
> "SELECT SUM(cash) FROM budgetitem WHERE [seach criteria...] AND
> MAX(notification)"

This is a pretty tough problem if you don't have sub-selects or don't want
to make two queries.  Here's a solution with a subselect:

FROM budgetitem
WHERE [search criteria...]
AND notification = (SELECT MAX(notification) FROM budgetitem)

It you don't have subselects, it's a lot trickier, so let me know and I'll
post a solution if possible.

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list