根据这个查询,我缺少了什么:5 u$ {: e+ I* J! j) b- w
SELECT mymonth,Header1FROM(SELECT month(startdatetime) as mymonth,(CASE WHEN MyTable.somecolumn =2 THEN count(somecolumn2) END) as Header1FROM MyTable WHERE year(startdatetime)=2013group by startdatetime) xGROUP BY Header1我在某个地方说Informix不支持按别名分组,但试图设置GROUP BY 2时出现红色错误,列标题1必须位于Group by子句中- W; c9 p4 v" d8 {) f1 n
' ~& a4 L- G4 L" ?9 `8 M( h# h1 H4 ? 解决方案: