SQL 只针对 ORACLE 数据库 :
with a as (
select count(1) sum from T_DATA_PUBLIC where datatype=‘lxzxsc’ and datamn=‘99999999999999’
)
select
case when a.sum = 0 then (SELECT ‘0’ as data FROM dual)
else
(SELECT data FROM T_DATA_PUBLIC where datatype=‘lxzxsc’ and datamn=‘99999999999999’)
end data
from a
这样 如果查不到数据 则数据显示为 0