select top 的速度,最快

SELECT TOP 1 *
FROM tb
WHERE id<=abs(checksum(newid()))%(select rowcnt from SYSINDEXES where id=object_id('tb') and indid<2 )+1
ORDER BY ID DESC
原文地址:https://www.cnblogs.com/zzxap/p/2175787.html