如上表所示,如何将num字段的YES变成Y,而NO变成N,即如下图:
SQL:(postgresql)
select id,
case
when num = 'YES' then 'Y'
when num = 'NO' then 'N'
else 'error'
end as result
from example
数据库表结构:
CREATE TABLE example
(
id integer NOT NULL,
num character varying(10),
CONSTRAINT example_pkey PRIMARY KEY (id)
)