Use of SQL to Search for Data (AQA GCSE Computer Science): Flashcards
📚Flashcards
Practise the cards
15 cards from this deck
ShowHide
Practise the cards
15 cards from this deck
SQL acronym
SQL acronym
Structured Query Language
SELECT keyword purpose
SELECT keyword purpose
Chooses which fields/columns to show
FROM keyword purpose
FROM keyword purpose
Chooses which table to look in
WHERE keyword purpose
WHERE keyword purpose
Filters results based on conditions
ORDER BY keyword purpose
ORDER BY keyword purpose
Sorts results in a particular order
Mandatory SQL keywords
Mandatory SQL keywords
SELECT and FROM
Optional SQL keywords
Optional SQL keywords
WHERE and ORDER BY
Asterisk (*) wildcard in SQL
Asterisk (*) wildcard in SQL
Selects all fields from a table
ASC in ORDER BY
ASC in ORDER BY
Ascending order (A-Z, smallest to largest)
DESC in ORDER BY
DESC in ORDER BY
Descending order (Z-A, largest to smallest)
Default ORDER BY sort
Default ORDER BY sort
ASC (ascending)
Primary key definition
Primary key definition
Unique identifier for each record in a table
Foreign key definition
Foreign key definition
References another table's primary key
Multi-table field format
Multi-table field format
TableName.FieldName
OR operator in SQL
OR operator in SQL
Matches records that meet ANY of multiple conditions