17,377
社区成员
发帖
与我相关
我的任务
分享
ResultSet rs = stmt.executeQuery("select department_id, sum(case when salary > 8000 then 1 else 0 end) t from employees group by department_id");
while(rs.next()) {
System.out.println(rs.getInt("t"));
}