Different Aggregation functions in SAP HANA

In a general scenario, it is advisable to store the table as Column store when you have to run complex OLAP queries. OLAP queries include complex calculations and different SQL aggregation functions are used in the query.

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

Aggregate Functions include −

• Sum() - returns the sum of the numeric values in a given column

• Max() - returns the maximum of the numeric values in a given column

• Min() - returns the minimum of the numeric values in a given column

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

• Percent() - returns the percentage of the numeric values in a given column

• Count() - returns the count of the numeric values in a given column

SAP ABAP Expert

Published on 05-Feb-2018 17:31:38

• Related Questions & Answers
• Multiple perspectives to perform different functions in SAP HANA
• SAP HANA database functions in HANA Cockpit
• Different SAP HANA Administration tools
• Different perspectives in SAP HANA Studio
• Different License types in SAP HANA
• Different Engine types in SAP HANA
• Different Package type in SAP HANA
• Different schema types in SAP HANA database
• Different table symbol in SAP HANA database
• Different Audit trial targets in SAP HANA
• Different authentication methods supported in SAP HANA
• Different Engine types in SAP HANA Architecture
• Using different Engine types in SAP HANA
• Join using CE functions in SAP HANA database
• Functions of Index server in SAP HANA system