Tracy FYI You can do it in Ansi SQL you just can't do it in FB 1.0 (it would appear)
IF and CASE are Ansi SQL functions Neven ----- Original Message ----- From: "Tracey Maule" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 3:10 PM Subject: Re: Re: [DUG]: multi aggregates with clauses?? > > 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/ > > --------------------------------------------------------------------------- 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/
