> Select extract(month from incident_date) as TheDate,ltiormti,count(*) > from incident > where companyid = companyid > and ... > group by extract(month from incident_date),ltiormti >
Problem is i dont need the count of all records Looks like my answer is no, i cant do it, so have done it in code. I just thought i should do what i can in sql..(trying to extend my sql knowledge) cheers anyway guys ----- Original Message ----- From: "Chris Reynolds" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 2:19 PM Subject: Re: Re: [DUG]: multi aggregates with clauses?? > Of course if you are processing the output with software, maybe the > following would do: > > 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/ > --------------------------------------------------------------------------- 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/
