用一条SQL语句如何取得数据库的第3,4,5条记录 ,并且延迟6秒钟执行
1、select top 3 * from (select top 5 * from tabName order by u_id ) a
order by u_id desc
2、select top M-N+1 * from (select top M * from tabName order by id asc ) t
order by id desc
3、select top M-N+1 * from (select top M * from tabName) t order by id desc
4、select top 5 * from tabName where id not in(select top 2 * from tabName)
5、select top 5 from tabName where id not in(select top 2 from tabName)
延迟6秒钟执行
waitfor delay '00:00:06' 

浙公网安备 33010602011771号