Key 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

See more

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

Pro Logo

How you'll master it

Stress-test your knowledge with quizzes that help commit syntax to memory

Pro Logo