复制代码 代码如下:
select * from tablename limit m, n
复制代码 代码如下:
select id from tablename
复制代码 代码如下:
select top 6 id from tablename
复制代码 代码如下:
select top 3 id from tablename
where id not in (
select top 6 id from tablename
)
复制代码 代码如下:
select top (n-m+1) id from tablename
where id not in (
select top m-1 id from tablename
)
复制代码 代码如下:
select top @pageSize id from tablename
where id not in (
select top @offset id from tablename
)
新闻热点
疑难解答