为什么这句话在PL/sql里执行没有问题。 SELECT WHSCODE,sum(CASE when status='空' then 1 else 0 end) NULLTorrNums FROM WAREHOUSEPOSITION GROUP BY WHSCODE
带到程序中，就报错，说缺少右括号。我原来以为是单引号截断sql语句。但是后来改成 CASE when 1=1 then 1 else 0 end
仍然报错。不知道什么原因。请帮忙。
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"));
}
SELECT WHSCODE,sum(CASE when status='空' then 1 else 0 end) as NULLTorrNums FROM WAREHOUSEPOSITION GROUP BY WHSCODE
--or
SELECT WHSCODE,sum(CASE when status='空' then 1 else 0 end) "NULLTorrNums" FROM WAREHOUSEPOSITION GROUP BY WHSCODE
