SELECT ZYH,XM,XB,(select dep_id from bagl_SQJGXX where v_name like '%CSD_SHI%'and i_level=2)CSD_SHI FROM VIEW_BAXTBRXX WHERE BAH='2018050041'该语句使用like '%csd_shi%'不能执行 请问正确写法怎么写
...全文
702打赏收藏
sql语句查询问题,求大神解惑!
SELECT ZYH,XM,XB,(select dep_id from bagl_SQJGXX where v_name like '%CSD_SHI%'and i_level=2)CSD_SHI FROM VIEW_BAXTBRXX WHERE BAH='2018050041'该语句使用like '%csd_shi%'不能执行 请问正确写法怎么写
SELECT ZYH,XM,XB,(select dep_id from bagl_SQJGXX where v_name like CONCAT (a.CSD_SHI,'%') and i_level=2)CSD_SHI FROM VIEW_BAXTBRXX a WHERE BAH='2018050041' 使用concat解决