| Name | Description | |
|---|---|---|
 | DB2SelectStatement Constructor | Creates a new instance of the DB2SelectStatement class. |
DB2SelectStatement Class Members
In This Topic
The following tables list the members exposed by DB2SelectStatement.
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) |
| Distinct | Gets or sets whether statement should request unique rows only. (Inherited from Devart.Common.SelectStatement) |
| GroupBy | Contains list of columns used in the GROUP BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement) |
| Having | Gets or sets HAVING clause of the statement. (Inherited from Devart.Common.SelectStatement) |
| 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) |
| Where | Gets or sets WHERE clause of the statement. (Inherited from Devart.Common.SelectStatement) |
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 | Overridden. Clears all parts of the DB2SelectStatement. |
 | Parse | Converts the specified SELECT statement to a DB2SelectStatement object. |
| ToString | Returns SQL statement in the text form. (Inherited from Devart.Common.SelectStatement) |
| TryParse | Tries to convert the specified SELECT statement to a DB2SelectStatement object. |
See Also