【数据库】case when

select rownum as rn,a.*,
case when depat_nam1 is null then parent_nam else depat_nam1 end as depat_nam

posted @ 2017-08-22 11:32  Legolas_4  阅读(109)  评论(0)  编辑  收藏  举报