数据窗口的ＳＱＬ

[gaojupeng]

数据窗口的ＳＱＬ为何分组不对，如下：
select "A"."A1","A"."A2",0 AS STATE,MAX("A"."A3")
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE

[eviler]

数据窗口的分组不是在这设置的

要在画板里面设置（create group）

[gaojupeng]

已解决，原来计算列，别名是不能放在group by里的

[SKY_4K_PPM]

select "A"."A1","A"."A2",0 AS STATE,MAX("A"."A3")
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE
========================================
MAX("A"."A3")是聚合函数，无法分组的阿.......

[lllyyymmm]

知道就好

[knowledge_Is_Life]

等待牛人来答.