Hi,

ı am trying to write an sql statement in informix, but it gives error.
Does Informix not support using day function with Group By statement ?

If not, is there a workaround ?

Statement is:

select day(call.startdatetime) , count(*) from call
where month(call.callstartdate) = 11
group by day(call.startdatetime);

Thanks.

You can use group by 1 in your "group by" statement with 1 representing the first column_name listed in your select statement.

Same rule applies when using an "order by" statement.

Thank you

you're very welcome, glad to help