SelectQuery Properties
A set of columns (from a single table or multiple joined tables) that forms a SELECT statement when executing a query.
Name | Description |
---|---|
Columns | Provides access to all columns included in the query result set. |
Distinct | Specifies whether or not a query result set should include duplicate values. |
Filter |
Specifies the criteria used to filter data returned by the current Select |
Group |
Specifies the filter criteria to add to the current Select |
Groups | Provides access to all groups specified for the current query. |
Isolation |
Specifies the isolation level for Sql |
Name |
Specifies the query name.
Inherited from Sql |
Parameters |
Provides access to the collection of parameters defined for the Sql |
Relations | Provides access to all data relations specified for the current query. |
Skip | Specifies the number of rows to skip in a returned query result set. |
Sorting | Provides access to all sorting criteria specified for the current query. |
Tables | Provides access to all tables selected by the current query. |
Top | Specifies the number of rows returned in the query result set. |
See Also