復(fù)制代碼 代碼如下:

select * from tablename limit m, n

復(fù)制代碼 代碼如下:

select id from tablename

復(fù)制代碼 代碼如下:

select top 6 id from tablename

復(fù)制代碼 代碼如下:

select top 3 id from tablename
where id not in (
select top 6 id from tablename
)

復(fù)制代碼 代碼如下:

select top (n-m+1) id from tablename
where id not in (
select top m-1 id from tablename
)

復(fù)制代碼 代碼如下:

select top @pageSize id from tablename
where id not in (
select top @offset id from tablename
)