KID A1 A2
nc_13250380221109 25.06 2793.30
nc_13250380221109 25.06 3990.42
nc_13250380221109 25.06 3990.42
nc_13250380221142 25.06 3990.42
nc_13250380221142 25.06 3990.42
nc_13250380221142 25.06 2793.30
nc_13250380221186 25.06 2793.30
nc_13250380221186 25.06 3990.42
nc_13250380221188 25.06 3990.42
nc_13250380221188 25.06 2793.30
nc_13250380221188 25.06 3990.42
nc_13250380221189 25.06 2793.30
nc_13250380221193 25.06 2793.30
nc_13250380221193 25.06 3990.42
nc_13250380221193 25.06 3990.42
nc_13250380221195 25.06 2793.30
nc_13250380221195 25.06 3990.42
nc_13250380221195 25.06 3990.42
nc_13250380221301 16.55 3021.15
nc_13250380221301 16.55 3021.15
如例子,要按照KID分组,分组后,每组随机取一条记录
------解决方案--------------------
- SQL code
select distinct b.*from tb across apply (select top 1 * from tb where kid=a.kid order by newid())b