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 25 - SELECT Firstname FROM People WHERE age > 25, Find first name of people with an age of 25 - SELECT Firstname FROM People WHERE age = 25, Find all fields for people that are called Smith and live in Portsmouth - SELECT * FROM People WHERE lastname = "Smith" AND Town = "Portsmouth", Find all fields for people that are called Smith or live in Portsmouth - SELECT * FROM People WHERE lastname = "Smith" OR Town = "Portsmouth", Find all fields for people whose first name begins with C - SELECT * FROM People WHERE Firstname LIKE 'C%',

SQL Match up quiz

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?