DataGrid连接Access的快速分页法（3）——SQL语句的选用（降序）

时间： 2021-07-31 作者：daque

datagrid贯穿access的赶快分页法（3）——sql语句的采用（降序）三、降序（1）@pageindex <= @firstindexselect top @pagesize @queryfields from @tablename where @conditionorder by @primarykey desc （2）@firstindex < @pageindex <= @middleindexselect top @pagesize @queryfields from @tablename where @primarykey < ( select min(@primarykey) from ( select top @pagesize*@pageindex @primarykey from @tablename where @condition order by @primarykey desc ) tablea ) where @condition order by @primarykey desc （3）@middleindex < @pageindex < @lastindexselect * from ( select top @pagesize @queryfields from @tablename where @primarykey > ( select max(@primarykey) from ( select top (@recordcount-@pagesize*(@pageindex+1)) @primarykey from @tablename where @condition -- order by @primarykey asc ) tablea ) where @condition -- order by @primarykey asc ) tableb order by @primarykey desc （4）@pageindex >= @lastindexselect * from ( select top (@recordcount-@pagesize*@lastindex) @queryfields from @tablename where @condition order by @primarykey asc) tablea order by @primarykey desc 四、归纳经过上头的计划，断定大师该当看到了该分页本领的上风地方。鄙人一篇中，我将给大师一个动静天生上头 sql 语句的类。

DataGrid连接Access的快速分页法（3）——SQL语句的选用（降序）

相关推荐

推荐下载

热门阅览

最新排行