SQL Flashcards
Card 1 of 5
All 5 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
FROMcommand specify?Which table the data is retrieved from.
In SQL, what does the
WHEREcommand do?e.g.
WHERE Year = 11Filters the records so only those meeting the condition are returned — only records whose Year is 11.
In SQL, how do you select more than one field?
e.g. the
NameandYearfieldsList the field names after
SELECT, separated by commas:SELECT Name, Year(notAND). List only the fields asked for:SELECT *returns every field.In an SQL
WHEREclause, what is the difference betweenANDandOR?ANDmeans all the conditions must be true;ORmeans at least one condition must be true.