SQL Flashcards

All 6 cards in this deck

In SQL, what does SELECT * do?

Retrieves all fields from the records that match the query.

In SQL, what does the FROM command specify?

Which table the data is retrieved from.

In SQL, what does the WHERE command do?

e.g. WHERE Year = 11

Filters the records so only those meeting the condition are returned — only records whose Year is 11.

In SQL, what does LIKE with the % wildcard do?

e.g. WHERE Name LIKE "S%"

Matches incomplete words or patterns — returns records whose Name begins with S.

In an SQL WHERE clause, what is the difference between AND and OR?

AND means all the conditions must be true; OR means at least one condition must be true.

What are the steps to write an SQL query that searches for data?

e.g. the names of pupils in Year 11 from the table Students

1. State the fields: SELECT Name
2. State the table: FROM Students
3. State the condition: WHERE Year = 11