Sql Server2000中的分页处理

来源:互联网 发布:让男人死心塌地知乎 编辑:程序博客网 时间:2024/06/08 08:48

select top pageOne * from TableName

where QueryWhere

and row_id not in (select top pageTwo  row_id from TableName

                               where QueryWhere

                               order by BH)

order by BH

原创粉丝点击