PrepAway - Latest Free Exam Questions & Answers

Which functioncan you use in your query to distinguish the row from a regular row to a subtotal row?

Refer to the Exhibit.

You are working on creating an OLAP query that outputs several rows of with summary rows of subtotals and
grand totals in addition to regular rows that may contain NULL as shown in the exhibit. Which functioncan you
use in your query to distinguish the row from a regular row to a subtotal row?

PrepAway - Latest Free Exam Questions & Answers

A.
GROUPING

B.
RANK

C.
GROUP_ID

D.
ROLLUP


Leave a Reply