PostgresSQL: Cube, RollUP, Grouping Sets, Partial Cube, AND Partial RollUP Operators

Posted byNotable OfficePosted inBig Data, business intelligence, data science, relational databases, sqlTags:, , ,

Continuing my SQL education, I have been working with PostgresSQL while taking online courses via Coursera. I have create some SQL statements using cube, rollup and grouping sets operators. See below:

Cube

ROLLUP:

Grouping Sets:

Partial Cube:

Partial RollUP:

Published by Notable Office

I am at the best when I use data and my expertise in process improvement to help individuals and small to large businesses reduce process costs, solve process/business problems, and improve efficiency, productivity and customer satisfaction.

Leave a comment