Analytic Functions
Analytic Functions let you apply grouping function to subset of record, you can also order the result set using specified values. Analytic functions are commonly used to compute cumulative, moving, centered, and reporting aggregates. Analytic functions can appear only in the select list or ORDER BY clause. OVER() In the OVER clause you have to put the field-fields on such you apply the function (sum,count,ecc.) If no arguments are specified , the set considered will be the same of the origin table. Ex. SELECT SUM(misura) OVER () … same as SELECT SUM(misura) … You can also use the ORDER...