就需要多条件下面是一个多条件判断的sql:
- select
- oper.opid,
- oper.user_name,
- oper.user_host,
- case
- when oper.oper_type = 1 then 'System Manager'
- when oper.oper_type = 2 then 'USER Manager'
- end case,
- case
- when oper.oper_object_type = 1 then 'User'
- when oper.oper_object_type = 2 then 'Role'
- when oper.oper_object_type = 3 then 'Broker'
- when oper.oper_object_type = 4 then 'QM Manager'
- when oper.oper_object_type = 5 then 'User Group'
- when oper.oper_object_type = 6 then 'Msg Flow'
- when oper.oper_object_type = 7 then 'Queue'
- end case
- from esb_log_user_oper oper;
select
oper.opid,
oper.user_name,
oper.user_host,
case
when oper.oper_type = 1 then 'System Manager'
when oper.oper_type = 2 then 'USER Manager'
end case,
case
when oper.oper_object_type = 1 then 'User'
when oper.oper_object_type = 2 then 'Role'
when oper.oper_object_type = 3 then 'Broker'
when oper.oper_object_type = 4 then 'QM Manager'
when oper.oper_object_type = 5 then 'User Group'
when oper.oper_object_type = 6 then 'Msg Flow'
when oper.oper_object_type = 7 then 'Queue'
end case
from esb_log_user_oper oper;