Is there a MAX function for rows - not columns?

Question

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

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

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

Answer 1

You need a GREATEST function

 SELECT GREATEST(column1, column2, column3) AS X 

Answer 2

SELECT GREATEST(column1, column2, column3) as max_value