由于sqlserver 子查询不支持order by,
SELECT COUNT(1)
FROM (
SELECT ****** from table order by time desc ) TOTAL;
除非另外还指定了 TOP、OFFSET 或 FOR XML,否则,ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效
使用Top 100 percent 的方法可以解决上述这个问题,但是分页组件进行分页查询时会在加上top 100 percent
WITH selectTemp AS (ELECT TOP 100 PERCENT ROW_NUMBER() OVER (order by tor.orderDate desc) as __row_number__, TOP (100) PERCENT if ........ SELECT *
FROM selectTemp
WHERE __row_number__ BETWEEN 1 AND 10 ORDER BY __row_number__;
sqlserver 会报语句错误。
处理方法:
//关闭count查询
Page p = new Page(bo.getPager().getPageNum(), bo.getPager().getPageSize(),false);
IPage<OrderBo> ticketList = orderMapper.getList(p, bo);
PageResult pageList = PageResult.ok(ticketList);
//自己写count查询
pageList.setTotal(Long.valueOf(orderMapper.getListCount(bo)));