SQL语句 case ... when

select 字段A, 字段B, CASE WHEN t.operate = 1 then 'aa'WHEN t.operate = 2 then 'bb'WHEN t.operate = 3 then 'cc'WHEN t.operate = 4 then 'dd'WHEN t.operate =
posted @ 2019-05-08 17:46  roundlight  阅读(385)  评论(0)  编辑  收藏  举报