Select Top 1 from a nested CTE

Transact-SQL
4 

;WITH cte_base AS (
    SELECT ROW_NUMBER() ... AS row_num, FeeType
    FROM ...
),
cte_nested AS (
    SELECT TOP (1) *
    FROM cte_base
    WHERE row_num = 1 
    ORDER BY FeeType
)
1 Like