Mybatis-plus 分页功能报错：除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效

由于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 selectTempWHERE __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)));