SQL SELECT * Tutorial - Learn Database Queries

SELECT *

Interactive SQL Tutorial

In SQL, data is usually organized in various tables. For example, a sports team database might have the tables teams, players, and games. A wedding database might have tables guests, vendors, and music_playlist.

Imagine we have a table that stores family members with each member’s name, species, gender, and number of books read.

Let’s start by grabbing all of the data in one table. We have a table called family_members that is shown below. In order to grab all of that data, please run the following command: SELECT * FROM family_members;

The * above means that all of the columns will be returned, which in this case are id, name, gender, species, and num_books_read.

SQL:

SQL SELECT * Tutorial - Interactive Database Query Lesson

Lessons

SELECT *

Query Result:

Available Tables:

Expected Result: