| Name | Description | |
|---|---|---|
 | SqlSelectStatement Constructor | Creates and initializes new instance of SqlSelectStatement. |
SqlSelectStatement Class Members
In This Topic
The following tables list the members exposed by SqlSelectStatement.
Public Constructors
Public Properties
| 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. |
Public Methods
| 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. |
See Also