使用：
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
使用：
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
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
