1,108
社区成员
发帖
与我相关
我的任务
分享数据窗口的ＳＱＬ
数据窗口的ＳＱＬ为何分组不对，如下：
select "A"."A1","A"."A2",0 AS STATE,MAX("A"."A3")
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE
select "A"."A1","A"."A2",0 AS STATE,MAX("A"."A3")
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE
...全文
请发表友善的回复…
发表回复
knowledge_Is_Life 2008-04-30
- 打赏
- 举报
等待牛人来答.
lllyyymmm 2008-04-10
- 打赏
- 举报
知道就好
SKY_4K_PPM 2008-04-09
- 打赏
- 举报
select "A"."A1","A"."A2",0 AS STATE,MAX("A"."A3")
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE
========================================
MAX("A"."A3")是聚合函数，无法分组的阿.......
FROM "A"
GROUP BY "A"."A1","A"."A2",STATE
========================================
MAX("A"."A3")是聚合函数，无法分组的阿.......
gaojupeng 2008-04-09
- 打赏
- 举报
已解决，原来计算列，别名是不能放在group by里的
eviler 2008-04-09
- 打赏
- 举报
数据窗口的分组不是在这设置的
要在画板里面设置（create group）
要在画板里面设置（create group）
