declare @d datetime set @d = getdate() select top 10 U_Name from Test1 where ID not in (select top 30 ID from Test1 order by ID desc) order by ID desc select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate()) go
declare @d datetime set @d = getdate() select top 10 U_Name from Test1 where ID not in (select top 30 ID from Test1 order by ID desc) order by ID desc select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate()) go
转载于:https://www.cnblogs.com/New-world/archive/2012/11/19/2777797.html