select (CASE WHEN ganrao_lx not in('20','22') then null else ganrao_lx end ) ganrao_lx,
(CASE WHEN shijian_lx not in('87') then null else shijian_lx end ) shijian_lx
from table
#ganrao_lx和shijian_lx 是数据对比的字段,not in 后面是对比的数据,对比不上则赋值为null。
select (CASE WHEN ganrao_lx not in('20','22') then null else ganrao_lx end ) ganrao_lx,
(CASE WHEN shijian_lx not in('87') then null else shijian_lx end ) shijian_lx
from table
#ganrao_lx和shijian_lx 是数据对比的字段,not in 后面是对比的数据,对比不上则赋值为null。