If I followed you correctly, you could keep your existing CTE and turn on aggregation in the main query. ROW_NUMBER() can be used to rank ...
確定! 回上一頁