SELECT
CASE
WHEN sort_num = 1 THEN ‘true’
WHEN sort_num = 2 THEN ‘false’
ELSE ‘none’
END
AS num
FROM base_area
SQL case when
最新推荐文章于 2024-09-01 18:06:09 发布
SELECT
CASE
WHEN sort_num = 1 THEN ‘true’
WHEN sort_num = 2 THEN ‘false’
ELSE ‘none’
END
AS num
FROM base_area