SELECT | StarRocks

📄️ SELECT

SELECT queries data from one or more tables, views, or materialized views.

Common Table Expression defines a temporary result set referenced multiple times within SQL statement scope.

DISTINCT keyword removes duplicate rows from query results.

EXCEPT/MINUS returns distinct results from left query not appearing in right query.

EXCLUDE keyword filters specified columns from SELECT * results, available from StarRocks v4.0.

GROUP BY clause groups rows by specified columns for use with aggregate functions.

HAVING clause filters aggregate function results rather than row data.

INTERSECT calculates the intersection of multiple query results.

Join operations combine data from two or more tables and return result columns.

LIMIT clause limits the maximum number of rows returned from query results.

OFFSET clause causes result set to skip initial rows and return following results.

ORDER BY clause sorts result set by comparing values from one or more columns.

PIVOT transforms rows into columns using aggregate functions, simplifying pivot table queries.

UNION combines results from multiple queries into a single result set.

SQL operators are functions used for comparison widely in WHERE clauses of SELECT statements.

Aliases assign shorter names to tables, columns, or expressions in queries.

如何在StarRocks中编写关联和非关联子查询，包括[NOT] IN、EXISTS、标量和lateral join形式。