SELECT | StarRocks

📄️ SELECT

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

Common Table Expression (CTE) defines temporary result sets referenceable within a SQL statement scope.

DISTINCT keyword removes duplicate rows from the result set.

EXCEPT/MINUS returns distinct results of the left-hand query not existing in the right-hand query.

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

GROUP BY clause organizes result rows into groups for use with aggregate functions.

HAVING clause filters aggregate function results rather than row data.

INTERSECT calculates the intersection of results appearing in all result sets.

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

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

OFFSET clause skips the first few rows and returns subsequent results.

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

PIVOT transforms rows into columns using aggregate functions for creating pivot tables.

UNION combines results from multiple queries, with optional deduplication.

SQL operators are functions used for comparison widely employed in WHERE clauses.

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

StarRocksで相関および非相関サブクエリを記述する方法。[NOT] IN、EXISTS、スカラ、lateral join形式を含みます。