BlueBrooke wrote:so what have you got so far?> Hi --
> I need to find the highest and lowest entries in a field, and calculate
> the difference. Can I do this with one query (mysql 4.0.2)?
> I'm just getting back into php/mysql after a year's absence, so I'm sorry
> if this is a basic question. I'm sure something simple is escaping me --
> and will come to me as soon as this hits the server. Googled into the wee
> hours with no success.
> Thanks for any help --
SELECT max( fieldname ) - min( fieldname )