oracle case when 在查詢時候的用法。

標籤：

select count(1), features_level  from (SELECT i.features_level,               i.features,               T.BASEAMINE_ID,               T.COLUMN_NAME,               V.COLUMN_VALUE,               V.DETAIL_ID,                              (case                 when i.features = ‘計數‘ AND V.COLUMN_VALUE = ‘NG‘ then                  0                 when (i.features = ‘計量‘ AND V.COLUMN_VALUE <> ‘-‘) and                      (to_number(V.COLUMN_VALUE) > i.offset_value_up or                      to_number(V.COLUMN_VALUE) <= i.offset_value_low) then                  0                 else                  1               end) as illLegal                  FROM OQC_BASE_STANDRAD_TITLE T         INNER JOIN OQC_BASE_STANDRAD_VALUE V            ON T.ID = V.COLUMN_ID, oqc_inspection_sample_item i         WHERE T.STATE = ‘A‘           AND T.BASEAMINE_ID = ‘EDF58BDBA5D14800B2C19B539EE795EF‘           and t.is_insepection_result = ‘1‘           and v.detail_id = i.id) where illLegal = 0 group by features_level  --select * from oqc_inspection_sample s   

　　

oracle case when 在查詢時候的用法。