ApsaraDB for ClickHouse supports a declarative query language based on SQL. It complies with the American National Standards Institute (ANSI) SQL standards in many cases.
Supported SQL features
| Feature | Description |
|---|---|
| GROUP BY | Aggregates rows that share a common value and computes summary statistics across groups. |
| ORDER BY | Sorts query results by one or more columns in ascending or descending order. |
| Subqueries in FROM | Uses the result of a nested SELECT as a derived table in the FROM clause. |
| JOIN clause | Combines rows from two or more tables based on a related column. |
| IN operator | Filters rows by testing whether a value matches any member of a list or subquery result. |
| Window functions | Performs calculations across a set of rows related to the current row without collapsing them into a single output row. |
| Scalar subqueries | Embeds a subquery that returns a single value directly in a SELECT list, WHERE clause, or expression. |
该文章对您有帮助吗？