[Resolved] Need to select maximum and minimum values

[mapexdrum]

Hello,

I need to select maximum and minimum values (ages) from a DB table.

I would figure that this is something simple; however, I cannot seem to make it work. I tried using the max() function to pick out of a string compiled during a loop previously done.

I have tried using separate queries and functions, all to no avail.

Any help is greatly appreciated.

Aaron

[devinemke]

SELECT MIN(age) AS min_age, MAX(age) AS max_age FROM table

[mapexdrum]

Thanks,

It worked...

I tried something similar to that but I had a group by at the end of it...nothing ever happened.

Thanks so much!