How to get the maximum value in each row

Question

I want to calculate the max value in each row. I have tried with Max(), and not worked.

Sample like this:

Answer 1

Hi @Lylyy

Please try this query:

DECLARE @tbl TABLE(val1 INT,val2 INT,val3 INT); 
INSERT @tbl VALUES(5,3,8),(2,9,4); 

SELECT *,(SELECT MAX(val) FROM (VALUES (val1),(val2),(val3)) AS value(val)) AS MaxVal  
FROM @tbl;  

Best regards,

Cosmog Hong

Answer 2

If you are on SQL 2022 or Azure SQL Database, you can use greatest:

SELECT greatest(val1, val2, val3)
FROM tbl

If you are on old versions, Cosmog's query is the best solution.