22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY 产品,卖场 ORDER BY NEWID()) 'ID',* FROM TABLE1
) T WHERE ID<=3
select t.* from table1 t where 销售人员 in (select top 3 销售人员 from table1 where 产品 = t.产品 and 卖场 = t.卖场 order by 销售人员) order by 产品 , 卖场 , 销售人员