一条分组后随机抽取的SQL语句

WITH TT AS
(SELECT *,rownum = row_number() over(partition by [分组字段] order by newid()) FROM 表名)
SELECT * FROM TT
where rownum = 1