SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [Order](OrderId INT, NegotiatedPrice DECIMAL(10,2), SuggestedPrice DECIMAL(10,2));
INSERT INTO [Order]
VALUES (1, 100.00, 120.00), (2, 50.97, 66.00)
2 rows affected

SELECT * 
FROM [Order]


OrderId
NegotiatedPrice
SuggestedPrice


1
100.00
120.00

2
50.97
66.00


SELECT o.OrderId, GREATEST(o.NegotiatedPrice, o.SuggestedPrice) AS Greatest
FROM [Order] o


OrderId
Greatest


1
120.00

2
66.00