Need help with max

[zeert2002]

Hi I need help with the max function.
How do I get the max of the queries result in sql?


my query is:
select val from table where id in(3,4);

It will give me two values. From this what should I add so that it will give me only 1 value and that value is the max of the two? Thanks.

 

[carp]

Well,

SELECT MAX(val)
FROM my_table
WHERE id IN (3,4)
GROUP BY id;

will give you the maximum value for each ID.
To narrow this down to the greatest of either of them, you could simply use

SELECT MAX(val)
FROM my_table
WHERE id IN (3,4);