SQL Server-每个状态提取X个随机记录

使用：

WITH sample AS ( SELECt t.*,        ROW_NUMBER() OVER (PARTITION BY t.state         ORDER BY NEWID()) AS rank   FROM ZIPCODES t)SELECt s.*  FROM sample s WHERe s.rank <= 5