Skip to content

Instantly share code, notes, and snippets.

@rmorenobello

rmorenobello/Oracle-Group by rollup with titles.sql

Created October 15, 2025 12:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rmorenobello/c0fdf8d3a7b5193eea9330e3687818eb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rmorenobello/c0fdf8d3a7b5193eea9330e3687818eb to your computer and use it in GitHub Desktop.
Download ZIP
Oracle - GROUP BY with rollup with titles
Raw
Oracle-Group by rollup with titles.sql
SELECT
CASE
WHEN GROUPING(REGION) = 1 THEN 'TOTAL GENERAL'
ELSE REGION
END AS REGION,
CASE
WHEN GROUPING(PRODUCTO) = 1 THEN 'TOTAL REGIÓN'
ELSE PRODUCTO
END AS PRODUCTO,
SUM(IMPORTE) AS TOTAL_VENTAS
FROM VENTAS
GROUP BY ROLLUP(REGION, PRODUCTO)
ORDER BY REGION, PRODUCTO;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment