发生“CASE ELSE”时从SQL中删除行

with TempResult (id, status)
as
(
    select primary_key_column,
           case when table.field1 = 1 then 1
                when table.field2 = 3 then 3
                when table.field2 = 4 then 4
                when table.field3 = 1 then 5
                else 0
    from table
)

select id
from TempResult
where status > 0

最严格的方法是从“when”开始为字段设置条件,即field1=1或field2 in(3,4)或field3=1