QuestionQ51

VerifiedAdvanced Analytics - Theory, Application, and Interpretation of Results for Eight Methods

Which SQL OLAP grouping extension returns a value for every output row, with 1 identifying a summary row and 0 identifying grouped rows?

Explanation

GROUPING flags whether a grouped column value represents a superaggregate generated by grouping operations such as ROLLUP or CUBE. It returns 1 for a summary (superaggregate) row and 0 for an ordinary grouped row.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!