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
AS
Clause
OR
Operator
%
Wildcard
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
- 1In this lesson, we will be learning different SQL commands to query a single table in a database. One of the core purposes of the SQL language is to retrieve information stored in a database. …
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