Is there MAX function for rows - not for columns?

Question

I need to get maximum value of certain number of columns (for each row). Is this possible to do in MySQL?

For example:SELECT MAX(column1, column2, column3).

I'm not looking for MAX function that aggregates values of a given column. I need to aggregate values of different columns for each row.

Answer 1

You need the GREATEST function

SELECT GREATEST(column1, column2, column3) AS X