var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Day function with Group By in Informix
ı 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 ?
select day(call.startdatetime) , count(*) from call
where month(call.callstartdate) = 11
group by day(call.startdatetime);
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.
you're very welcome, glad to help