[OT] SQL help

Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm

what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____  

> From: Monique Boea > > what is OT? Off Topic

Try this (where age is the formula you're already using). I'd recommend making a view that has the age as one of the columns. SELECT CASE   WHEN age <= 16 THEN 1        WHEN age BETWEEN 17 AND 25 THEN 2        WHEN age BETWEEN 26 AND 40 THEN 3        ELSE 4 END  AS [group] ________________________________________ Sent: Wednesday, 26 May 2004 8:22 a.m. To: CF-Talk Subject: [OT] SQL help Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm ________________________________________

Thnx Matthew works great.... brilliant! Success! ----- Excess quoted text cut - see Original Post for more -----

Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____  

Thanks :) Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____   _____  

You are welcome..... ;-) Thanks :) Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____   _____   _____