select case when 字段1 >0 and 字段2 =1 then '待审批' when 字段1 =0 then '未审批' else '已审批' end as 字段自定义1, case when 字段3 =1 then '已付款' else '未付款' end as 字段自定义2 from 表
排序-看的更明白:
select
case when 字段1 >0 and 字段2 =1
then '待审批'
when 字段1 =0
then '未审批'
else '已审批'
end as 字段自定义1,
case when 字段3 =1
then '已付款'
else '未付款'
end as 字段自定义2
from 表