# SQL Statements

## Content



DataConnector supports multiple SQL queries for different database operations. The table below describes supported SQL statements.

| **Name** | **Clauses** | **Examples** |
| --- | --- | --- |
| SELECT |   FROM   | SELECT \* FROM Account |
|  | WHERE | SELECT \* FROM Account WHERE FirstName <> 'John'; |
|  | JOIN |   SELECT ID, NAME, AMOUNT, DATE<br />FROM CUSTOMERS<br />INNER JOIN ORDERS<br />ON CUSTOMERS.ID = ORDERS.CUSTOMER\_ID;<br /><br /><br />  Similarly, Left Join, Left Outer Join, and Cross Join can be used.   |
|  | UNION/UNION ALL | SELECT FirstName FROM Account<br />UNION<br />SELECT CustomerID FROM Customer;<br /><br /> |
|  | GROUP BY | SELECT \* FROM Account GROUP BY Country; |
|  | Aggregate Functions |   SELECT MIN(amount\_paid) FROM Accounts;  Similarly, Max, Sum, Avg, and Count fucntions can be used.   |
|  | LIMIT OFFSET | SELECT FullName FROM Account LIMIT 10 |
|  | ORDER BY | SELECT \* FROM Account ORDER BY ASC; |
| UPDATE |  | Refer [CRUD operations](/componentone/docs/services/online-dataconnector/ado.net-provider-for-odata/odatacrudoperations) topic |
| INSERT |  | Refer [CRUD operations](/componentone/docs/services/online-dataconnector/ado.net-provider-for-odata/odatacrudoperations) topic |
| DELETE |  | Refer [CRUD operations](/componentone/docs/services/online-dataconnector/ado.net-provider-for-odata/odatacrudoperations) topic |