sql 抽取数据解决思路
sql 抽取数据
用存储过程 怎么将 1001 取两条 1002 取两条 1003 取两条 1004 取两条 随机取的
------解决思路----------------------
row_number分组，组号小于3，用order by newid就是随机了
------解决思路----------------------
--根据楼上的
select * from
(select rn=ROW_NUMBER() over (partition by Agentid order by newid()),* from TB) a
where rn<3
------解决思路----------------------
用存储过程 怎么将 1001 取两条 1002 取两条 1003 取两条 1004 取两条 随机取的
------解决思路----------------------
row_number分组，组号小于3，用order by newid就是随机了
------解决思路----------------------
--根据楼上的
select * from
(select rn=ROW_NUMBER() over (partition by Agentid order by newid()),* from TB) a
where rn<3
------解决思路----------------------
CREATE PROC test
AS
BEGIN
SELECT * FROM
(SELECT RN=ROW_NUMBER() OVER (PARTITION BY AGENTID ORDER BY NEWID()),* FROM TB) A
WHERE RN<3
END
--执行
exec test