MUL

Purpose

This function returns the product of expr within a window or group of rows.

Syntax

mul::=

MUL

Usage Notes

  • With DISTINCT, the function considers duplicate values of expr only once. It considers all occurrences with ALL. If the function contains neither ALL nor DISTINCT, the default is ALL.
  • This function supports only arguments of type numeric.
  • The return type of this function is always DOUBLE PRECISION.

Examples

Aggregate Function

SELECT MUL(annual_inflation) total_inflation_rate FROM inflation_rates;

Analytic Function

SELECT 
     relevant_year,     MUL(annual_inflation) OVER (ORDER BY relevant_year ASC ROWS BETWEEN 4 PRECEDING AND CURRENT ROW) 
     inflation_last_five_years FROM inflation_rates;
Result
RELEVANT_YEAR INFLATION_LAST_FIVE_YEARS
2019 0.9562890809252812
2018 0.6718044944677499
2017 0.5488795376685
2016 0.73397238276636
2015 3.150062672356664
2014 6.799120347140375
2013 2.1860055962437137
2012 1.516164236540237
2011 0.7596774408960001
2010 0.35401344
2009 0.3264