sql代码实现分页技术

2014-11-24 10:13:39 · 作者: · 浏览: 0

sql代码实现分页技术
[sql] www.2cto.com
select top 12 * from Fm_model_main where docid < (
select min(docid) from (
select top 24 * from Fm_model_main order by docid desc )
as tabTap)
order by docid desc