SELECT
(
CASE degree
WHEN '1' THEN
'简单'
WHEN '2' THEN
'中等'
ELSE
'困难'
END
) AS degree,
degree AS degree1
FROM
te_questionmain
Sql 之 case函数
最新推荐文章于 2023-11-19 07:30:00 发布
SELECT
(
CASE degree
WHEN '1' THEN
'简单'
WHEN '2' THEN
'中等'
ELSE
'困难'
END
) AS degree,
degree AS degree1
FROM
te_questionmain