Find all fields for people called FRED - Select * from People where firstname = "FRED", Field - A single piece of data about someone or something, Record - A collection of fields about someone or something, Find firstname of people with an age above 25 - Select Firstname from People where age > 25, Find firstname 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",

SQL Instructions

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?