I have a query in which WHERE clause returns nothing. Sysdate is 2/25/2019.
I still want to display '0' when nothing is returned. How could I do it? Thanks in advance!
with test1 as
(
select 1 col1
from dual
where sysdate > '26-feb-2019'
)
select nvl(col1,0) col1
from test1