如何動態地SELECT Transact-SQL 陳述式中編號 ... - Microsoft Support

select row_number() over (order by qty desc) as rank,s1.stor_id,s1.qty from ( select stor_id, qty=sum(qty) from sales ...

support.microsoft.com