sql

SQL错误

2020-09-07 06:40发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中) 如何将该查询转换为sql ...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


如何将该查询转换为sql sap Hana?

从(选择年份(from_unixtime(t.timestamp/1000))作为txn_year,MONTHNAME(from_unixtime(t.timestamp/1000))作为txn_month,count(t.id)中选择txn_year,txn_month,sum(transaction_volume)作为transaction_volume )来自type_4 t

的transaction_volume

其中t.assetId =" EvN8cvuGKC2t1PA8ZEsgJth3paenSP4UAd8Z6K14z2P4" GROUP BY txn_month,txn_year联合选择year(from_unixtime(t.timestamp/1000))作为txn_year,MONTHNAME(from_unixtime(t。) id)来自type_11 t
的transaction_volume,其中t.assetId =" EvN8cvuGKC2t1PA8ZEsgJth3paenSP4UAd8Z6K14z2P4" GROUP BY txn_month,txn_year)sd GROUP BY txn_month,txn_month',''''''' ," 5月"," 6月"," 7月"," 8月"," 9月"," 10月"," 11月"," 12月");

1条回答
小c菟菟
2020-09-07 07:19

您好 jass kopov

您是否尝试过此工具- https://github.com/B1SA/HanaTranslator-Src将查询转换为SQL SAP Hana格式?

此致

山姆

一周热门 更多>