sql 高效随机获取大表数据

 

SELECT TOP 100

                NickName

        FROM    [dbo].[tbEPUsers] WITH(NOLOCK)

        WHERE   0.01 >= CAST(CHECKSUM(NEWID(), [NickName]) & 0x7fffffff AS FLOAT)

                / CAST(0x7fffffff AS INT)