Select extract(month from incident_date) as TheDate,ltiormti,count(*) from incident where companyid = companyid and ... group by extract(month from incident_date),ltiormti
Hi
yes, sql again i have a simple table, which holds a date (incident_date) and a type (ltiormti) of incident. ltiormti has a value of either L, M, N or null I need to retrieve how many L's occur in each month, over the last 12 months, and how many M's etc.....
I am creating a report (html) which is to chart ratios of each type of incident. what i was wondering is if i can do something like this without a stored procedure:
Select extract(month from incident_date) as TheDate, //these bits are the bits i need, but cannot do (select sum(ltiormti) where ltiormti = 'L') as LTI, (select sum(ltiormti) where ltiormti = 'M') as MTI
from incident where companyid = companyid and ((extract(month from incident_date) >= 3 and extract(year from incident_date) >= 2002) or (extract(month from incident_date) < 3 and (extract (year from incident_date) = 2003))) order by incident_date
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
