关于PageHelper无法使用Having关键字查询的问题

昨天遇到一个问题,使用PageHepler的时候它会使用一个select cout语句去查询你的sql条件,

如果没有数量为0就不会执行你的SQL语句,但是当你的SQL语句使用Having关键字就会报错

所以必须重写cout语句,怎么重写呢,在你分页的Mybaits语句id后面新建一个查询,后缀加上_COUNT.

但是SQL语句半天没整出来 现在终于弄好了 作为子表查询数量就可以了.

因为CSDN没有XML的格式,直接贴图了

select a.pk_id,
       (select count(1) from a apply where apply.enabled = 1 and apply.enabled = 1) dueCount
from b as sig
         inner join study_tutor_train_sign sign on sign.pk_id = a.sr and sign.enabled = 1
where sig = sig.enabled = 1
having dueCount > 4;

select count(1)
from (select a.pk_id,
             (select count(1) from a apply where apply.enabled = 1 and apply.enabled = 1) dueCount
      from b as sig
               inner join study_tutor_train_sign sign on sign.pk_id = a.sr and sign.enabled = 1
      where sig = sig.enabled = 1
      having dueCount > 4) as t1