SelectingRows

Selecting Rows

Selecting rows that satisfy a "Row Condition" (See Row Conditions on the documentation website.) can occur in the following two types of operations:

• Selecting entire rows (Entire-Row Condition), for instance in filter, drop, first, and count (using RowFilter).

• Selecting parts of rows using a where operation after selecting columns (Row-Value Condition), such as with update, gather, and format (using RowValueFilter).

A Row Condition is similar to a Row Expression but expects a Boolean as result.