AWS – Amazon Redshift announces general availability of ROLLUP, CUBE, and GROUPING SETS in GROUP BY clause
Amazon Redshift now supports new SQL functionalities including ROLLUP, CUBE, and GROUPING SETS, to simplify building multi-dimensional analytics applications. ROLLUP, CUBE, and GROUPING SETS simplifies data warehouse migrations by offering the commonly used syntax across databases.
Read More for the details.