SQL SELECT specific columns Tutorial - Learn Database Queries

Lessons

SELECT specific columns

Interactive SQL Tutorial

SELECT * grabs all fields (called columns) in a table. If we only wanted to see the name and num_books_read columns, we would type
SELECT name, num_books_read FROM family_members;.

Can you return just the name and species columns?

SQL:

SQL SELECT specific columns Tutorial - Interactive Database Query Lesson

Lessons

SELECT specific columns

Query Result:

Available Tables:

Expected Result: