Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

Question

Aryan Kumar · Answer

No, there is no built-in MAX function in SQL Server that takes two values. The MAX function only takes one parameter, and it returns the maximum value of all the values in a column.

However, there are a few ways to get the maximum of two values in SQL Server. One way is to use the following code:

SQL

SELECT MAX(value1, value2);

This code will return the maximum value of the two values value1 and value2.

Another way to get the maximum of two values in SQL Server is to use a CASE statement. The following code shows how to use a CASE statement to get the maximum of two values:

SQL

SELECT
CASE
WHEN value1 > value2 THEN value1
ELSE value2
END AS mavalue;

This code will return the maximum value of the two values value1 and value2. If value1 is greater than value2, then the mavalue column will contain the value of value1. Otherwise, the mavalue column will contain the value of value2.

Finally, you can also use a user-defined function (UDF) to get the maximum of two values in SQL Server. The following code shows how to create a UDF to get the maximum of two values:

SQL

CREATE FUNCTION maof_two(@value1 INT, @value2 INT)
RETURNS INT
AS
BEGIN
DECLARE @mavalue INT;
SET @mavalue = @value1;
IF @value2 > @value1
SET @mavalue = @value2;
RETURN @mavalue;
END;

This code creates a UDF called maof_two that takes two integer parameters and returns the maximum value of the two parameters.

forum

Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

Can you answer this question?

1 Answers