case_opt_then.sql 180 B

12345
  1. select case when true then cast("123" as int) else 100501 end
  2. union all
  3. select case when true then NULL else 100502 end
  4. union all
  5. select case when false then NULL else 100503 end;