Find all fields for people called FRED - SELECT * FROM People WHERE firstname = "FRED", Column - Collection of data values of the same type, Record/row - Collection of information about someone or something, Find first name of people with an age above 15 - SELECT Firstname FROM People WHERE age > 15, Find first name of people with an age of 15 - SELECT Firstname FROM People WHERE age = 15, Find all fields for people that are called Smith and live in Bathgate - SELECT * FROM People WHERE lastname = "Smith" AND Town = "Bathgate", Find all fields for people that are called Smith or live in Bathgate - SELECT * FROM People WHERE lastname = "Smith" OR Town = "Bathgate", Find all fields for people whose first name begins with C - SELECT * FROM People WHERE Firstname LIKE 'C%',

SQL Match up quiz - select with LIKE

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?