How to find the Max From (5,8,124,498)
--Get Max Number from the list
SELECT
(SELECT Max(v) FROM (VALUES (5), (6), (7)) AS value(v)) as [MaxValue]
--Get Max Date from the list
SELECT getdate(),
(SELECT Max(v) FROM (VALUES (getdate()), (getdate()+1), (getdate()+2)) AS value(v)) as [MaxDate]
--Syntex
SELECT
COL1,
(SELECT Max(v) FROM (VALUES (5), (6), (7)) AS value(v)) as [MaxValue],
COL2
FROM
TABLE1