SQL

Terms

7 terms

CTE
A CTE (common table expression) in SQL is a named temporary result set defined with WITH and used by a single query, including recursive queries.
GROUP BY
GROUP BY in SQL collapses rows that share the same values in chosen columns into groups, so aggregate functions return one result per group.
HAVING
HAVING is the SQL clause that filters groups produced by GROUP BY using conditions on aggregate values such as COUNT, SUM or AVG.
JOIN
A JOIN in SQL combines rows from two or more tables into one result set by matching values in related columns, such as a foreign key…
SELECT
SELECT is the SQL statement that retrieves data from database tables, declaring which rows and columns to return and leaving the execution plan to the engine.
Subquery
A subquery in SQL is a SELECT statement nested inside another statement, supplying a value, a list or a derived table to the outer query.
Window function
A window function in SQL computes a value for each row from a related set of rows, such as running totals or rankings, without collapsing rows.