分页查询SQL的处理问题

暴风雪
2017-03-02 10:54

在分页查询count时候，order by 会被去掉，但是如果在sql中要使用 over() 分析函数，order by 被去掉显然是不合理的，要如何避免呢

项目：JFinal

评论区

暴风雪

2017-03-02 10:54

@JFinal

暴风雪

2017-03-02 10:55

String totalRowSql = "select count(*) " + config.dialect.replaceOrderBy(sqlExceptSelect);

暴风雪

2017-03-02 10:56

@lyh061619 @toni

lyh061619

2017-03-02 11:27

外层再套一层select*如：
String select = "select a2.*";
String form = " from(select a.id, a.number, a.name, a.desc, date_format(a.creat e_at, '%Y-%m-%d') createAt, " +
"(select count(id) amount from goods where dept_id = a.id) amount from goods a) a2 where 1=1";
String orderBy = " order by a2.create_at, a2.amount desc ";