making categories from a table 1

[cihatkarli]

i have cell named age in my table.

i want a query like this.

ages between 18-25 will be in first column 26-30 in second 31-35 in third.

is it possible?

thanks.

 

[r937]

yes, it is

select foo
     , count(
         case when age between 18-25 
              then 'count this one'
              else null end ) as age_18_25
     , count(
         case when age between 26-30 
              then 'count this one'
              else null end ) as age_26_30
     , count(
         case when age between 31-35 
              then 'count this one'
              else null end ) as age_31_35
  from daTable
group
    by foo

r937.com | rudy.ca

 

[cihatkarli]

holy *

i want to cry :'(

Thanks man. wow

 

[r937]

my bad, i typed too fast

change

... BETWEEN 18-25

to

... BETWEEN 18 AND 25


r937.com | rudy.ca

 

[cihatkarli]

i noticed it. thanks.