1.在利用数据库语句select count(1) from table,在获取返回值时,不能强制转换为integer和Long,将结果转换为number再进行获取整形或长整形值即可。
2.将count(1)作为返回字段并对其进行排序:
SELECT * FROM (SELECT b.col1 as col1,COUNT(b.col1) as count FROM table b GROUP BY b.col1) t GROUP BY t.count
1.在利用数据库语句select count(1) from table,在获取返回值时,不能强制转换为integer和Long,将结果转换为number再进行获取整形或长整形值即可。
2.将count(1)作为返回字段并对其进行排序:
SELECT * FROM (SELECT b.col1 as col1,COUNT(b.col1) as count FROM table b GROUP BY b.col1) t GROUP BY t.count