求一句简单的SQL语句

来源：百度知道编辑：UC知道时间：2024/05/24 19:47:41

我想查出TAB1表中的,第6到12条数据,怎么写呢?
不要NOT IN ,速度太差了
我是想分页,一页6条数据

select top 7 * from
(select top 12 * from TAB1) order by id desc

Select Top 7 * From TAB1
Where id>(Select Max(id) From
(Select Top 5 Id From Table Order By id Asc) Temp)
Order By id Asc

分页的话可以不用SQL语句实现
GridView自身不就可以实现吗

select * from
( select tab1.*, row_number() as rownum from tab1) as tempTab
where rownum between 6 and 12;