SQL Server-每个状态提取X个随机记录 [英] SQL Server - pull X random records per state

问题描述

我有一张桌子，上面有美国每个邮政编码的记录.为了在地图上显示，我需要为每个州选择X个随机记录.我将如何去做?

I have a table with records for each zip code in the united states. For the purposes of displaying on a map, I need to select X random records per state. How would I go about doing this?

推荐答案

使用:

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

这篇关于SQL Server-每个状态提取X个随机记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！