SQL WHEN CASE

最新推荐文章于 2024-09-21 10:25:52 发布

lsfa1234

最新推荐文章于 2024-09-21 10:25:52 发布

阅读量521

点赞数

分类专栏： sql 文章标签： sql join

本文链接：https://blog.csdn.net/lsfa1234/article/details/4142185

版权

sql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

sql="select id,qiye,hangye,zhengche,jb,sh,dizhi,tel,dianji,daima,(case sheng when '"&sheng&"' then '6' else '2' end) as aa from d_zhuce where sheng='"&sheng&"' and xian like '%"&xian&"%' union select a.id as id,a.qiye as qiye,a.hangye as hangye,a.zhengche as zhengche,a.jb as jb,a.sh as sh,b.dizhi as dizhi,b.tel as tel,a.dianji as dianji,b.daima,(case b.dizhi when '"&sheng&"' then '6' else '2' end) as aa from d_zhuce a inner join d_wangdian b on a.id=b.q_id where b.dizhi like '%"&xian&"%' and qylb='专线' order by aa,daima"