Query Glossary
Browse 6 query terms defined in plain English, from the cultural dictionary of computing.
6 Query Terms
- Clause
- A distinct component of a SQL statement or logical expression that specifies a condition or operation. In SQL, clauses like WHERE, GROUP BY, and HAVING filter,...
- CTE
- Common Table Expression — a named temporary result set defined within a SQL statement using the WITH clause. Makes complex queries readable by breaking them...
- Lateral Join
- A SQL join where the right-hand subquery can reference columns from the left-hand table — like a correlated subquery but returning multiple rows/columns....
- LINQ
- Language Integrated Query — a C#/.NET feature that adds SQL-like query syntax directly into the programming language for filtering, transforming, and...
- SQL
- SQL, or Structured Query Language, is the standard language for managing and querying relational databases. Developed at IBM in the 1970s based on Edgar Codd's...
- Window Function
- A SQL function that performs a calculation across a set of rows related to the current row, without collapsing them into a single result (unlike GROUP BY)....