SQL Server 类似于 foreach

使用row_number()：

select rc.*
from (select region, customerid, sum(extendedPrice) as price,
             row_number() over (partition by region order by sum(extendedprice) desc) as seqnum
      from invoices
      group by region, customerid
     ) rc
where seqnum <= 2;