SELECT top 1 * FROM TABLE1 TABLESAMPLE SYSTEM (10 PERCENT)
Select top (10) percent * from TABLE1 order by NewID()
SELECT top 1 * FROM TABLE1
WHERE 0.10 >= CAST(CHECKSUM(NEWID(), SS_Number) & 0x7fffffff AS float) / CAST (0x7fffffff AS int)
第1种存在取不到数据的情况,第2种慢,第3种最佳