SAP HANA SQL Expression Tutorial

Details

SQL Expressions is a clause that can be used for return values. There are 4 types of SQL Expressions-

Aggregate Name Description
COUNT Count the Number of rows returned by the query.
MIN Return the minimum value of the expression.
MAX Return the maximum value of the expression.
SUM Return the sum of expressions.
AVG Return the arithmetical mean of expressions.
STDDEV Return the Standard Deviation of given expressions as the square root of VARIANCE function.
VAR Return the variance of expressions as the square of standard deviation

 

YOU MIGHT LIKE:
SAP-HANA

SAP HANA Reporting

We have till now loaded data from SAP Source, Non-SAP, and Flat file through SAP SLT, SAP BODS and...