sql:当一列为空时取另一列(case when then)
select sbid, act_type from (select case when imei is null then idfa else imei end as sbid,act_type,act_time from rela_load where act_type=52 or act_type=54 or act_type=55 or act_type=56 or act_type=57
原创
2016-01-06 10:45:46 ·
19074 阅读 ·
0 评论