查询的某字段不为空的写法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')
查询的某字段不为空的写法
SELECT
i.zch zch,
i.zzmc zzmc,
i.longtitude qydzX,
i.latitude qydzY
FROM
ind_qyzt_jbxx i
WHERE i.sfgsqy = '1'
AND (i.zch IS NOT NULL
AND i.zch != '')
![Oracle通过case when条件判断和instr字符串查找修改查询结果[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)