oracle几种求合计的方法.pdfVIP

oracle几种求合计的方法

EnglishAnswer:

OracleprovidesseveralmethodstocalculateSUM()

aggregatefunctions,including:

1.SUM(expression):Calculatesthesumofanumeric

expressionwithinagroupofrows.

2.SUM(DISTINCTexpression):Calculatesthesumof

distinctvaluesofanumericexpressionwithinagroupof

rows.

3.SUM()OVER(PARTITIONBYclause):Calculatesthesum

ofanumericexpressionoverapartitiondefinedbythe

PARTITIONBYclause.

4.SUM()OVER(ORDERBYclause):Calculatestherunning

totalofanumericexpressionoveragroup