select OrderID ,Amount ,row_number() over (order by Amount desc) as SalesRank into #t1 from Orders group by OrderID, Amount; select * from #t1 where SalesRank <= 5