Ansicht
Dokumentation

ABENAGGREGATE_SHORTREF - AGGREGATE SHORTREF

General Material Data   PERFORM Short Reference  
This documentation is copyright by SAP AG.

sql_agg

Reference

Syntax

... { MAX( [DISTINCT] col )
    | MIN( [DISTINCT] col )
    | AVG( [DISTINCT] col )
    | SUM( [DISTINCT] col )
    | COUNT( DISTINCT col )
    | COUNT( * )
    | COUNT(*) } ... .

Effect

Aggregate expressions in queries.

Additions

• AVG( $[DISTINCT$] col  $[AS dtype$] )
  Average value of the values in the column col with an optional target data type dtype specified.

• MAX( $[DISTINCT$] col$|sql_exp )
  Maximum value of the results of the SQL expression sql_exp.

• MIN( $[DISTINCT$] col$|sql_exp )
  Minimum value of the results of the SQL expression sql_exp.

• AVG( $[DISTINCT$] col )
  Average value of the results of the SQL expression sql_exp.

• SUM( $[DISTINCT$] col$|sql_exp )
  Total of the results of the SQL expression sql_exp.

• STRING_AGG( sql_exp$[,sep$] $[ORDER BY col1$[ASCENDING$|DESCENDING$], ...$] )
  Chaining of the results of the SQL expression sql_exp.

• COUNT( $[DISTINCT$] col$|sql_exp )
  Number of the results of the SQL expression sql_exp.

• COUNT( * ), COUNT(*)
  Number of rows in the result set.
  
  

• COUNT( $[DISTINCT$] col$|sql_exp )
  Number of the results of the SQL expression sql_exp.
  

• COUNT( * ), COUNT(*)
  Number of rows in the result set.
  

Vendor Master (General Section)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 2223 Date: 20240501 Time: 235757     sap01-206 ( 25 ms )