Enum PredicateType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies query predicates that control result set filtering and limiting.

public enum PredicateType

Fields

All = 1

Returns all rows (no predicate modifier).

Distinct = 2

Returns only distinct (unique) rows, eliminating duplicates.

DistinctRow = 3

Returns distinct rows (similar to Distinct, database-specific variant).

Top = 4

Limits the result set to the first N rows.

TopPercent = 5

Limits the result set to the first N percent of rows.

Remarks

Predicates modify the behavior of SELECT queries by limiting the number of rows returned or removing duplicates. Different databases support different predicate types.