关于分页总记录数的获取问题
sql语句是这样的：
String sql = "select * from (select distinct " + column + ",rownumber() over(order by r.rcdId) as m from tableName) as a where a.m between " +startNum + " and "+endNum;
该怎样得到里层select的记录总数？用count()报错
[解决办法]
select * from (select distinct " + column + ",count(*) as count ,rownumber() over(order by r.rcdId) as m from tableName group by "+column+ ") as a where a.m between " +startNum + " and "+endNum
[解决办法]
String sql = "select * from (select distinct " + column + ",rownumber() over(order by r.rcdId) as m from tableName) as a where a.m between " +startNum + " and "+endNum;
----------------------------
1、r.rcdId 这个字段从何而来不清楚
2、要向获得里层的记录数 那么只要取 max(m) 就可以了 但是 楼主rownumber() over(order by r.rcdId) 似乎不是从1 开始的 需要修改一下
