Name | Description | |
---|---|---|
![]() | SqlSelectStatement Constructor | Creates and initializes new instance of SqlSelectStatement. |
The following tables list the members exposed by SqlSelectStatement.
Name | Description | |
---|---|---|
![]() | SqlSelectStatement Constructor | Creates and initializes new instance of SqlSelectStatement. |
Name | Description | |
---|---|---|
![]() | All | Gets or sets the value, indicating if the all records are selected or only the unique ones. (Inherited from Devart.Common.SelectStatement) |
![]() | Columns | Contains list of columns and expressions used in the select-list of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement) |
![]() | ComputeBy | Gets a COMPUTE BY clause of a SELECT statement. |
![]() | Distinct | Gets or sets whether statement should request unique rows only. (Inherited from Devart.Common.SelectStatement) |
![]() | For | Gets a SELECT FOR clause of a SELECT statement. |
![]() | GroupBy | Contains list of columns used in the GROUP BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement) |
![]() | GroupByInfo | Gets GROUP BY clause parameters of a SELECT statement. |
![]() | Having | Overridden. Gets or sets HAVING clause of the statement. |
![]() | Options | Gets or sets OPTIONS clause of a SELECT statement. |
![]() | OrderBy | Contains list of columns used in the ORDER BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement) |
![]() | Tables | Contains list of tables and subqueries used in the FROM clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement) |
![]() | Top | Gets a TOP clause of a SELECT statement. |
![]() | Where | Overridden. Gets or sets WHERE clause of the statement. |
Name | Description | |
---|---|---|
![]() | AddHavingCondition | Adds new condition to HAVING clause of the statement, represented by the Having property. (Inherited from Devart.Common.SelectStatement) |
![]() | AddWhereCondition | Adds new condition to WHERE clause of the statement, represented by the Where property. (Inherited from Devart.Common.SelectStatement) |
![]() | Clear | Clears all parts of the Devart.Common.SelectStatement. (Inherited from Devart.Common.SelectStatement) |
![]() ![]() | Parse | Overloaded. Converts the specified SELECT statement to a SqlSelectStatement object. |
![]() | ToString | Returns SQL statement in the text form. (Inherited from Devart.Common.SelectStatement) |
![]() ![]() | TryParse | Tries to convert the specified SELECT statement to a SqlSelectStatement object. |