oracle 里面加条件判断,oracle 查询的时候加条件判断
oracle 查询的时候加条件判断方法一.select a.idcard,SUM(CASE WHEN a.subject_code=2 THEN a.SCOPE ELSE 0 END),SUM(CASE WHEN a.subject_code=3 THEN a.SCOPE ELSE 0 END),SUM(CASE WHEN a.subject_code=4 THEN a.SCOPE ELSE ...
