Found a query that works:
WITH CTE_ResultSet AS
(
SELECT [column5] FROM [dbo].[table2] WHERE [column1ID] = 5
UNION
SELECT NULL
)
SELECT [column5] FROM
(SELECT [column5], ROW_NUMBER() OVER(ORDER BY [column5] DESC) AS RID FROM CTE_ResultSet) tmp
WHERE RID = 1
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP