Using an Aggregate function in SAP HANA

You can use an aggregate function to get the same. Common aggregation functions are −

Average() − returns the average of the numeric values in a given column

Select Average (Sales) from table_name where Column1=’ABC’; 

Anil SAP Gupta

Published on 21-Feb-2018 18:25:31

• Related Questions & Answers
• Using Aggregate function to fetch values from different tables in SAP
• Loading an individual column in SAP HANA using SQL
• Calling an ABAP Function Module using Python script to put data in SAP HANA
• Using aggregated in SAP HANA
• Using SAP HANA Cockpit for HANA Administration
• Use of SPATIAL function in SAP HANA
• Using an Analytic Privilege for specific time in SAP HANA
• Using Time subtype of an attribute view in SAP HANA
• Using parallel processing in SAP HANA
• Using temporary license in SAP HANA
• Using Analytic View in SAP HANA
• Using packages in SAP HANA studio
• Using Attribute view in SAP HANA
• Using Text join in SAP HANA
• Using database view in SAP HANA