Skip to content

Instantly share code, notes, and snippets.

@rmorenobello
Created October 15, 2025 12:23
Show Gist options
  • Select an option

  • Save rmorenobello/c0fdf8d3a7b5193eea9330e3687818eb to your computer and use it in GitHub Desktop.

Select an option

Save rmorenobello/c0fdf8d3a7b5193eea9330e3687818eb to your computer and use it in GitHub Desktop.
Oracle - GROUP BY with rollup with titles
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