SQL语句中的case when 的用法
select t.planno 计划单号, case when t.state=‘0’ then ‘未审核’ when t.state=‘1’ then ‘已审核’ else ‘已拒绝’ end 状态 from planapply t ;
SQL语句中的case when 的用法
select t.planno 计划单号, case when t.state=‘0’ then ‘未审核’ when t.state=‘1’ then ‘已审核’ else ‘已拒绝’ end 状态 from planapply t ;