Child pages
  • Enhanced Aggregation, Cube, Grouping and Rollup

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This function returns a bitvector corresponding to whether each column is present or not. For each column, a value of "01" is produced for a row in
the result set if that column has been aggregated in that row, otherwise the value is "10". This can be used to differentiate when there are nulls
in the data.

Consider the following example:

...