select top (1) with ties id ... order by row_numer() over (partition by id order by id desc)

IF OBJECT_ID('tempdb..#T') IS NOT NULL 
DROP TABLE #T
IF OBJECT_ID('tempdb..#TT') IS NOT NULL 
DROP TABLE #TT

CREATE TABLE #T (N BIGINT NOT NULL, N1 AS N % 47629 PERSISTED, N2 AS N % 63949 PERSISTED);
CREATE CLUSTERED INDEX IX_#T ON #T(N, N1, N2);
CREATE TABLE #TT (N1 BIGINT NOT NULL);
CREATE CLUSTERED INDEX IX_#TT ON #TT(N1);

WITH N100 AS 
( -- цифры от 0 до 99
	SELECT 0 AS N
	UNION ALL 
	SELECT N100.N + 1 FROM N100
	WHERE N100.N < 99
) 
INSERT INTO #T(N)
SELECT N = N1.N + N2.N * CAST(100 AS BIGINT)+ N3.N * CAST(10000 AS BIGINT) + N4.N * CAST(100000 AS BIGINT) FROM N100 AS N1, N100 AS N2, N100 AS N3, N100 AS N4
WHERE N4.N < 2; -- эту цифру можно менять в диапазоне от 1 до 100 для увеличения объема данных 

INSERT INTO #TT(N1)
SELECT DISTINCT N1 FROM #T;

IF OBJECT_ID('tempdb..#Result1') IS NOT NULL 
DROP TABLE #Result1
IF OBJECT_ID('tempdb..#Result2') IS NOT NULL 
DROP TABLE #Result2

PRINT CONVERT(CHAR(25), GETDATE(), 121)

SELECT T1.N1, T2.N 
INTO #Result1
FROM #TT T1
OUTER APPLY 
(
	SELECT TOP 1 N FROM #T T2
	WHERE T2.N1 = T1.N1
	ORDER BY N2 DESC 
) T2

PRINT CONVERT(CHAR(25), GETDATE(), 121)

SELECT T1.N1, T2.N 
INTO #Result2
FROM #TT T1
LEFT JOIN 
(
	SELECT DISTINCT T2.N1,  
		N = FIRST_VALUE(N) OVER (PARTITION BY T2.N1 ORDER BY N2 DESC)
	FROM #T T2
) T2 ON T2.N1 = T1.N1

PRINT CONVERT(CHAR(25), GETDATE(), 121)

CREATE CLUSTERED INDEX IX_#T ON #T(N1, N2, N);