var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
thanks all members for guidance
Today my question is that i have one table named shop in which i have 2 fields one is city and the other one is status.
in city field i have the following entries
and in the status field i have the following entries
now i want a build report to display the following data
the above example shows that in Brisbane city 10 shops are active, 10 shops are defaulter, 2 shops are closed and total shows that 22 shops are located in Brisbane city.
now plz help how to build this report
SELECT CITY,SUM(DECODE(STATUS,'active',1,0)) ACTIVE,
GROUP BY CITY
order by city;
You do not need a parachute to skydive. You only need a parachute to skydive twice.