SELECT
SELECT queries data from one or more tables, views, or materialized views.
CTE
Common Table Expression (CTE) defines temporary result sets referenceable within a SQL statement scope.
DISTINCT
DISTINCT keyword removes duplicate rows from the result set.
EXCEPT/MINUS
EXCEPT/MINUS returns distinct results of the left-hand query not existing in the right-hand query.
EXCLUDE
EXCLUDE keyword filters specified columns from SELECT * results, available from StarRocks v4.0.
GROUP BY
GROUP BY clause organizes result rows into groups for use with aggregate functions.
HAVING
HAVING clause filters aggregate function results rather than row data.
INTERSECT
INTERSECT calculates the intersection of results appearing in all result sets.
JOIN
Join operations combine data from two or more tables and return columns from them.
LIMIT
LIMIT clause limits the maximum number of rows returned in query results.
OFFSET
OFFSET clause skips the first few rows and returns subsequent results.
ORDER BY
ORDER BY clause sorts the result set by comparing values from one or more columns.
PIVOT
PIVOT transforms rows into columns using aggregate functions for creating pivot tables.
UNION
UNION combines results from multiple queries, with optional deduplication.
WHERE and Operators
SQL operators are functions used for comparison widely employed in WHERE clauses.
Alias
Aliases assign shorter or alternate names to tables, columns, or expressions in queries.
Subquery
StarRocksで相関および非相関サブクエリを記述する方法。[NOT] IN、EXISTS、スカラ、lateral join形式を含みます。