[MSSQL] 그룹별 TOP 1 랜덤 뽑기

WITH CTE_LIST 

AS ( 

SELECT *,ROW_NUMBER() OVER(PARTITION BY 컬럼 ORDER BY NEWID()) AS ROWN 

FROM 테이블 

 ) SELECT * FROM CTE_LIST 

WHERE ROWN <= 1 ORDER BY 컬럼,ROWN 







SELECT * 

 FROM (

SELECT *,ROW_NUMBER() OVER(PARTITION BY 컬럼 ORDER BY NEWID()

) AS ROWN 

FROM 테이블

) XX WHERE XX.ROWN = 1