< style="left: 0px; top: 0px;" id="stL" ="stL" height="350" ="http://edge.sharethis.com/share4x/index.08494d37c792aa82b4ba36e63cbd06f6." Border="0" width="353" allowTransparency="true" name="stL" scrolling="no">>
I have this query in Command
select (select name from mastlocationcode where
type = 'DIST' and code = m.district) as "Division",
count(incident_num) as
"Incidents"
from incident i, mastlocation m
where m.recnum =
i.locn_rec
and to_date(reported_on) >= '01-jan-2011'
and to_date(reported_on) <= '31-dec-2011'
group by
m.district
order by m.district
The client wants monthly report with
two parameter Begin and End date (like the client wants to enter begin and end
date for each month and get the result (like Begin Date (3/1/2011 and End date
3/31/2011) in this case client gets monthly report for march.
Please I
need help