mssql 按时间分页的问题 按时间分页不准确,按照ID分页没问题,这个是怎么回事呢?求哥哥姐姐帮忙
string sql = " select top " + NumPerPage + " * from Base_Sale where DateTime not in (select top " + ((PageNum - 1) * NumPerPage) + " DateTime from Base_Sale where 1=1 " + GetWhere() + " order by DateTime desc) " + GetWhere() + " order by DateTime desc";
如果用ID进行分页的话查出来的结果是没有问题的,可是用时间进行分页,查出来的结果不准确,请教还有别的写法吗?
select top 20 * from Base_Sale where DateTime not in (select top 40 DateTime from Base_Sale where 1=1 order by DateTime desc) order by DateTime desc