My code snippets

Name: Querying with different aggregate levels

Author: Rob Vonk

Language: Oracle

Description:
Use oracle Analytic functions to report data from different aggregate levels

Snippet:

SELECT level1, level2, MAX(fld) OVER (PARTITION BY level1) AS MAX_FLD

FROM table1