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 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, how do you select more than one field?

e.g. the Name and Year fields

List the field names after SELECT, separated by commas: SELECT Name, Year (not AND). List only the fields asked for: SELECT * returns every field.

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.