|  | This document is archived and information here might be outdated. Recommended version. | 
| ArcObjects Help for .NET developers > ArcObjects namespaces > Geodatabase > ESRI.ArcGIS.GeoDatabase > Constants > E > esriSQLClauses Constants (ArcObjects .NET 10.5 SDK) | 
SQL Clauses.
| Constant | Value | Description | 
|---|---|---|
| esriSQL_DISTINCT | 1 | SQL Distinct clause. | 
| esriSQL_ALL | 2 | SQL ALL clause. | 
| esriSQL_AS | 4 | SQL AS clause. | 
| esriSQL_ORDER_BY | 8 | SQL Order By. | 
| esriSQL_GROUP_BY | 16 | SQL Group By. | 
| esriSQL_SELECT_LIST | 32 | SQL Select List. | 
| esriSQL_FROM | 64 | SQL From. | 
| esriSQL_WHERE | 128 | SQL Where. | 
| esriSQL_HAVING | 256 | SQL Having. | 
| esriSQL_EXPRESSION | 512 | SQL Expression. |