File: select_case.sql

package info (click to toggle)

sqlfluff 3.5.0-2

file content (7 lines) | stat: -rw-r--r-- 130 bytes

select
  case fruit_code
    when 0 then 'apple'
    when 1 then 'banana'
    when 2 then 'cashew'
  end as fruit
from some_table