See what we can offer to your school
"SimpleStudy just makes sense...”
Get the best plan for your school
15 cards from this deck
Structured Query Language
Chooses which fields/columns to show
Chooses which table to look in
Filters results based on conditions
Sorts results in a particular order
SELECT and FROM
WHERE and ORDER BY
Selects all fields from a table
Ascending order (A-Z, smallest to largest)
Descending order (Z-A, largest to smallest)
ASC (ascending)
Unique identifier for each record in a table
References another table's primary key
TableName.FieldName
Matches records that meet ANY of multiple conditions
Select your subjects, and get access to A+ resources today.