请问下: 现有5列属性:A B C D AMOUNT. 最原始基础的SQL是 SELECT A,B,C,D,SUM(AMOUNT) FROM TABLE GROUP BY A,B,C,D 可不可以通过帆软操作使得:当选定ABCD中的部分列时,能够以其中的部分列聚合,且A,B,C,D列组成一个下拉框,根据用户的选择,从而看到更加整体、宏观些的数据。比如,当选定A、B两列时,实际查询变为: SELECT A,B,SUM(AMOUNT) FROM TABLE GROUP BY A,B
select count(1) FROM sdi_sap_saphanadb.BIC_AZEX_D092 a LEFT JOIN sdi_sap_saphanadb.BIC_AZMD_D022 bon a.MATNR=b.MATNRand MTART in ('Z001','Z002')LEFT JOIN sdi_sap_saphanadb.BIC_AZEX_D022 c on b.MATNR = c.MATNRand c.LFART='ZLF'WHERE c.WBSTA='C'