"Karthik" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> A question about "case when"
>
> i have the following table
> create table test(
>id integer primary key,
>category text,
>rating integer
> )
> the "rating" column takes value 1 to 5,
> I need to get number of 1 to
A question about "case when"
i have the following table
create table test(
id integer primary key,
category text,
rating integer
)
the "rating" column takes value 1 to 5,
I need to get number of 1 to 5 rated records for each category and for
this i used the query,
select
category,
2 matches
Mail list logo
