sql-server - 随机删除表中 75% 的内容

Question

尝试创建较小的样本数据库，但仍使数据在统计上具有一定的相关性。如何从表中删除 x% 的行？一直在玩弄 NEWID() 函数。

Answer 1

DELETE 
FROM TABLE_NAME
WHERE PK IN (SELECT TOP (75) PERCENT PK
             FROM TABLE_NAME
             ORDER BY NEWID())

马丁·史密斯的建议

DELETE T 
FROM (SELECT TOP (75) PERCENT * 
      FROM TABLE_NAME 
      ORDER BY NEWID()) T