SQL Grouping

[akli_agha]

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.

[Wild_Pointer]

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.

[akli_agha]

Thanks Wild_Pointer,

It works on firebird too.