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