查询的有关问题

查询的问题
mdbsql   =   "select   top   "&Page_size& "   *   from   table   where   id   <   (select   min   (id)   from   (select   top   "&(currentPage-1)*Page_size& "   id   from   table   order   by   id   desc)   as   T)   order   by   id   desc "

这样能正常显示
问题是当我要用日期排序
即
mdbsql   =   "select   top   "&Page_size& "   *   from   table   where   id   <   (select   min   (id)   from   (select   top   "&(currentPage-1)*Page_size& "   id   from   table   order   by   date   desc)   as   T)   order   by   date   desc "

就会少了很多条结果
不明白为什么

[解决办法]
看上去,好像是分页码