Queries
Perform more complex queries by learning essential query keywords and functionality
StartKey Concepts
Review core concepts you need to learn to master this subject
AND
Operator
%
Wildcard
AS
Clause
OR
Operator
SELECT
Statement
_
Wildcard
ORDER BY
Clause
LIKE
Operator
AND
Operator
AND
Operator
SELECT model
FROM cars
WHERE color = 'blue'
AND year > 2014;
The AND
operator allows multiple conditions to be combined. Records must match both conditions that are joined by AND
to be included in the result set. The given query will match any car that is blue and made after 2014.
Queries
Lesson 1 of 1
What you'll create
Portfolio projects that showcase your new skills
How you'll master it
Stress-test your knowledge with quizzes that help commit syntax to memory