Zeoslib Portal

Hi,

I want to group my data by 2 groups. My criteria is a date.
Then one group would be before this date and the other group after this date. How to write the sql script to have this ??

D7, FB2.0, XP SP2

Thanks.

akli_agha,

SELECT sum(price) FROM payments
group by case when sale_date > '2010.01.01' then 1 else 2 end

At least this works for postgresql.

Good luck.

Thanks Wild_Pointer,

It works on firebird too.