sql查询第10条到第20条数据

select top(10) * from T1 where Id >= (select MAX(Id) from (select top(20) * from T1 order by Id) as t)

posted @ 2012-09-07 17:18  +-/\-+  阅读(989)  评论(0编辑  收藏  举报