摘要:
declare @t1 datetime,@total intset @t1=GETDATE()select rowId,BuildName from (select top 2896 row_number() over( order by id asc) rowId,BuildName from tbl_data_House order by id asc) tb where tb.rowId>10 and tb.rowId10 and tb.rowId10 and tb.rowId10 and tb.rowId<=20print datediff(ms,@t1,getdate( 阅读全文