# SQL glossary: Journeyman level

20 SQL terms at the Journeyman level, each with a short definition and a link to its full page.

Updated: September 28, 2026

[Study these as flash cards](https://www.ask-codey.com/decks/sql/journeyman)

- [Alias](https://www.ask-codey.com/glossary/alias): An Alias is an alternate (usually short) name assigned to a table to make it easier to…
- [COMMIT](https://www.ask-codey.com/glossary/commit): A statement that successfully ends a transaction and makes its changes durable.
- [Common Table Expression (CTE)](https://www.ask-codey.com/glossary/common-table-expression-cte): A named query expression introduced by WITH for use within one statement.
- [Correlated Subquery](https://www.ask-codey.com/glossary/correlated-subquery): A subquery that refers to values from an outer query and is evaluated in that context.
- [DENSE_RANK](https://www.ask-codey.com/glossary/dense-rank): A window function assigning equal rank to peers without leaving gaps after ties.
- [LAG](https://www.ask-codey.com/glossary/lag): A window function returning a value from an earlier row in the window partition.
- [LEAD](https://www.ask-codey.com/glossary/lead): A window function returning a value from a later row in the window partition.
- [OVER Clause](https://www.ask-codey.com/glossary/over-clause): The clause defining the row window used by a window function.
- [PARTITION BY](https://www.ask-codey.com/glossary/partition-by): An OVER subclause dividing query rows into independent window-function groups.
- [RANK](https://www.ask-codey.com/glossary/rank): A window function assigning equal rank to peers and leaving gaps after ties.
- [READ COMMITTED](https://www.ask-codey.com/glossary/read-committed): An isolation level preventing a statement from reading uncommitted changes.
- [READ UNCOMMITTED](https://www.ask-codey.com/glossary/read-uncommitted): The isolation level allowing the broadest concurrency and permitting dirty reads.
- [Recursive CTE](https://www.ask-codey.com/glossary/recursive-cte): A CTE that repeatedly refers to its own accumulated result until no new rows are produced.
- [REPEATABLE READ](https://www.ask-codey.com/glossary/repeatable-read): An isolation level preventing reread rows from changing during the transaction.
- [ROLLBACK](https://www.ask-codey.com/glossary/rollback): A statement that reverses a transaction's uncommitted changes.
- [ROW_NUMBER](https://www.ask-codey.com/glossary/row-number): A window function assigning consecutive numbers to rows within each window partition.
- [SAVEPOINT](https://www.ask-codey.com/glossary/savepoint): A named point inside a transaction to which later work can be rolled back.
- [SERIALIZABLE](https://www.ask-codey.com/glossary/serializable): The strongest standard isolation level, requiring results consistent with some serial order.
- [Window Frame](https://www.ask-codey.com/glossary/window-frame): The subset of rows around the current row used by a window function.
- [Window Function](https://www.ask-codey.com/glossary/window-function): A function calculating across related rows without collapsing them into one row per group.

- Previous level: [Apprentice](https://www.ask-codey.com/glossary/subjects/sql/apprentice)
- Next level: [Freelancer](https://www.ask-codey.com/glossary/subjects/sql/freelancer)

[Every SQL term, by level](https://www.ask-codey.com/glossary/subjects/sql)

Source: https://www.ask-codey.com/glossary/subjects/sql/journeyman