Hello,

I am a newbie to IB.

In MySQL I can use the next select:

select Year, Month, SUM(Sales) from sales group by Month;

However, this does not seem to work in IB.

I've figured a way around it using:

select MIN(Year), MIN(Month), SUM(Sales) from sales group by Month;

Is this supposed to be?

Kind regards,

Arno Rog
Amsterdam