ποΈ SELECT
SELECT queries data from one or more tables, views, or materialized views.
ποΈ CTE
You can use a common table expression (CTE) to define a temporary result set that you can reference possibly multiple times within the scope of a SQL statement.
ποΈ DISTINCT
The DISTINCT keyword deduplicates the result set.
ποΈ EXCEPT/MINUS
Returns distinct results of the left-hand query that do not exist in the right-hand query.
ποΈ EXCLUDE
This feature is supported starting from version 4.0.
ποΈ GROUP BY
The GROUP BY clause is often used with aggregate functions.
ποΈ HAVING
The HAVING clause does not filter row data in a table, but filters the results of aggregate functions.
ποΈ INTERSECT
Calculates the intersection of the results of multiple queries, that is, the results that appear in all the result sets.
ποΈ JOIN
Join operations combine data from two or more tables and then return a result set of some columns from some of them.
ποΈ LIMIT
LIMIT clauses are used to limit the maximum number of rows returned.
ποΈ OFFSET
The OFFSET clause causes the result set to skip the first few rows and return the following results directly.
ποΈ ORDER BY
The ORDER BY clause of a SELECT statement sorts the result set by comparing the values from one or more columns.
ποΈ PIVOT
This feature is supported from v3.3 onwards.
ποΈ UNION
Combines the result of multiple queries.
ποΈ WHERE and Operators
SQL operators are a series of functions used for comparison and are widely used in where clauses of select statements.
ποΈ Alias
When you write the names of tables, columns, or expressions that contain columns in a query, you can assign them an alias.
ποΈ Subquery
Subqueries are categorized into two types in terms of relevance:
