Search⌘ K
Home
Courses
Learn SQL

Solution: Pick the Columns You Want

Understand how to write SQL queries that retrieve only the columns you need from a table. This lesson teaches you to use the SELECT statement effectively to specify which data to display, improving your ability to ask precise questions of a database.

We'll cover the following...

Query

SELECT type, name FROM pets;

Explanation

This SQL query retrieves only specific columns, ...