Please enable JavaScript to use CodeHS

Intro SQL Glossary

Flashcards

Course:

Module:

Search:

WHERE Clause General

A SQL condition that filters results from a `SELECT` query

Comparison Operators General

Symbols used in conditions (`=`, `!=`, `>`, `<`, `>=`, `<=`)

Condition General

A logical expression that restricts what data is returned

Filter General

To narrow down a set of results based on rules

AND General

A logical operator that requires multiple conditions to be true

BETWEEN General

A SQL operator used to filter results within a range (inclusive)

LIKE General

A SQL operator used for pattern matching in text data

IN General

A SQL operator that checks if a value matches any value in a given list

Compound Condition General

A condition that uses multiple filters together

ORDER BY General

A SQL clause that sorts the returned query results by one or more columns

ASC General

Ascending order; the default sort direction

DESC General

Descending order; used to reverse the default sorting

JOIN General

A SQL operation that combines rows from two or more tables based on a related column.

Cross Join General

A join where each row in one table is paired with every row in another.

Foreign Key General

A field in one table that refers to the primary key in another table.

Alias General

A temporary name assigned to a column or table using the `AS` keyword in SQL

AS General

A SQL keyword used to rename fields or tables in the query result