WITH TT AS
(SELECT *,rownum = row_number() over(partition by [分组字段] order by newid()) FROM 表名)
SELECT * FROM TT
where rownum = 1
转载于:https://www.cnblogs.com/scorpioyyy/archive/2009/06/25/1510850.html
WITH TT AS
(SELECT *,rownum = row_number() over(partition by [分组字段] order by newid()) FROM 表名)
SELECT * FROM TT
where rownum = 1
转载于:https://www.cnblogs.com/scorpioyyy/archive/2009/06/25/1510850.html