Compare query, how?
Posted: Sun Mar 14, 2004 3:16 pm
How can i compare two values in single query and then return only the bigger one? I have a table where 2 cols 'country' and 'count'.
like: which country has bigger count, Germany or Sweden? Then return (print) the one, that has bigger value.
I could do this with PHP, but i need a query this time (so i can query MySQL directly with SSH).
Thanks.
like: which country has bigger count, Germany or Sweden? Then return (print) the one, that has bigger value.
I could do this with PHP, but i need a query this time (so i can query MySQL directly with SSH).
Thanks.