sir , Can we write aggregate SQL functions for making sum of total amount by grouping with payment mode SELECT pm, amount count(amount) as total amount FROM tablename GROUP BY pm ORDER by PM IDK This query is right or wrong but can we do sum by SQL functions
Yes you can. In SAP ABAP New syntax playlist , You can refer the videos of aggregate functions( video no - 42 to 45) . You will get the same kind of code. th-cam.com/play/PLM3lhmHjSeIQ-EaA5mRnGV1HO7Dlln855.html&si=FPpr58StdkvinwrC
at new and at end of can we pass multiple fields ? like compare values of 2-3 fields if same then add
We can not pass multiple fields using AT NEW and AT END OF. You can use ON CHANGE OF. We can pass multiple fields using ON CHANGE OF.
sir , Can we write aggregate SQL functions for making sum of total amount by grouping with payment mode
SELECT pm, amount count(amount) as total amount
FROM tablename
GROUP BY pm
ORDER by PM
IDK This query is right or wrong but can we do sum by SQL functions
Yes you can. In SAP ABAP New syntax playlist , You can refer the videos of aggregate functions( video no - 42 to 45) . You will get the same kind of code.
th-cam.com/play/PLM3lhmHjSeIQ-EaA5mRnGV1HO7Dlln855.html&si=FPpr58StdkvinwrC