MyBatis-Plus sqlserver 构造器查询查询出现问题

当前使用版本(必填,否则不予处理)

3.4.2

该问题是如何引起的？(确定最新版也有问题再提!!!)

group by 和 order by

重现步骤(如果有就写完整)

    lqw.groupBy("djxx.xlh");
    lqw.orderByDesc("djxx.xlh");
    List<XgSampleRecordVo> list = iXgSampleRecordService.XgXlhCount(page,lqw);**

   同时出现group by  和order  by时就会报错

报错信息

同时出现group by  和order  by时报错：

 SQL: SELECT COUNT(*) FROM (SELECT djxx.xlh AS sampleCode, COUNT(djxx.xlh) AS count FROM xg_djxx djxx JOIN xg_sample_record xsr ON xsr.djxx_id = djxx.id WHERE (djxx.bgzt IN (1, 2)) GROUP BY djxx.xlh ORDER BY djxx.xlh DESC) TOTAL

Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。

; uncategorized SQLException; SQL state [S0001]; error code [1033]; 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。]