SQL (OCR GCSE Computer Science): Flashcards
📚Flashcards
Practise the cards
12 cards from this deck
ShowHide
Practise the cards
12 cards from this deck
What does SQL stand for?
What does SQL stand for?
Structured Query Language
What does SELECT do?
What does SELECT do?
Specifies columns to retrieve
What does * mean in SELECT?
What does * mean in SELECT?
All columns
What does FROM do?
What does FROM do?
Specifies the table to retrieve data from
What does WHERE do?
What does WHERE do?
Filters results based on conditions
BETWEEN operator function
BETWEEN operator function
Searches for values within a range
LIKE operator function
LIKE operator function
Searches for patterns in text fields
IN operator function
IN operator function
Specifies multiple values for a column
AND operator requirement
AND operator requirement
Both conditions must be true
OR operator requirement
OR operator requirement
At least one condition must be true
<> or != operator meaning
<> or != operator meaning
Not equal to
Parentheses () purpose in SQL
Parentheses () purpose in SQL
Groups conditions for complex queries