点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我具有以下自定义脚本,并且我试图...
点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我具有以下自定义脚本,并且我试图...
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
我具有以下自定义脚本,并且我试图添加sql脚本以仅提取V_SERVICEMETERREADING.SMU的最大数量
我的脚本如下:
选择
V_SERVICEMETERREADING.MACHINE_N,
V_SERVICEMETERREADING.READINGDATE,
V_SERVICEMETERREADING.SMU_Q,
V_SERVICEMETERREADING.SMU
从
V_SERVICEMETERREADING
在哪里
V_SERVICEMETERREADING.READINGDATE>(从双中选择sysdate-1)
AND
V_SERVICEMETERREADING.SMU_Q> 2
AND
V_SERVICEMETERREADING.MACHINE_N
在
(
'174672',
'174674',
'174675',
" 174677",
'174678',
'174679',
'194617',
'304206',
'304207',
'304215',
'304243',
'304244',
'304245',
'304246',
'304247',
'304248',
'304249',
'314266')
你好丹尼尔
您能帮我试试下面的自定义脚本吗?
选择V_SERVICEMETERREADING.MACHINE_N,V_SERVICEMETERREADING.READINGDATE,V_SERVICEMETERREADING.SMU_Q,MAX(V_SERVICEMETERREADING.SMU)
从V_SERVICEMETERREADING
V_SERVICEMETERREADING.READINGDATE>(从双中选择sysdate-1)AND V_SERVICEMETERREADING.SMU_Q> 2 AND V_SERVICEMETERREADING.MACHINE_N in('174672','174674','174675','174677','174678','174679 ','194617','304206','304207','304215','304243','304244','304245','304246','304247','304248','304249','314266')
按V_SERVICEMETERREADING.MACHINE_N,V_SERVICEMETERREADING.READINGDATE,V_SERVICEMETERREADING.SMU_Q分组
Shankar
感谢您解决此问题
一周热门 更多>