how to make count() return 0 instead of NULL ?
547350Jul 24 2007 — edited Jul 24 2007Hallo
if i have a query like this :
select something ,count(*) from table where something='...' group by something;
and if no rows found,then oracle returns
no rows selected.
Is it somehow possible to change it to the following :
something 0
I.e is it possible to have 0 and not null when there are no results?