更新时间:2023-02-03 15:27:28
select top 10 percent * from [yourtable] order by newid()
针对有关大型表的纯垃圾"评论,您可以这样做以提高性能.
In response to the "pure trash" comment concerning large tables: you could do it like this to improve performance.
select * from [yourtable] where [yourPk] in
(select top 10 percent [yourPk] from [yourtable] order by newid())
此操作的成本将是对值进行键扫描再加上联接成本,在较大的表上选择较小的百分比应该是合理的.
The cost of this will be the key scan of values plus the join cost, which on a large table with a small percentage selection should be reasonable.