SELECT
FAULTCOMP,ERROR_DEV_IP,ERROR_DEV_NAME,
(CASE
WHEN ERROR_LEVEL=1 THEN '严重'
WHEN ERROR_LEVEL=2 THEN '高'
WHEN ERROR_LEVEL=3 THEN '中'
WHEN ERROR_LEVEL=4 THEN '低'
WHEN ERROR_LEVEL=5 THEN '信息'
WHEN ERROR_LEVEL=9 THEN '恢复消息'
END)
ERROR_LEVEL
,FIRSTTIME,(CASE WHEN
DEAL_STATE=0 THEN '未处理' WHEN
DEAL_STATE=1 THEN '已处理' WHEN
DEAL_STATE=2 THEN '已关闭' WHEN DEAL_STATE=3
THEN '重新打开' ELSE '' END)
DEAL_STATE,BUS_SYSNAME FROM TABLE_T
【SQL】在数据库中做出判断,改变要显示的内容,case when可以做到,oracle中实现
最新推荐文章于 2021-12-10 13:30:12 发布