BBampaa

Lessons › SQL › Chapter 1: Reading data

SQL lesson

SELECT all columns

SELECT * is helpful for learning and quick exploration. In real reporting, analysts often select only the columns they need.

Try this lesson free →
About 5–10 minutes · no sign-up needed

Example

Viewing a Full Retail Product Table with SELECT *

SELECT * FROM products

Result:

Step by step

  1. SELECT tells SQL what you want to see.
    SELECT
  2. The asterisk symbol means all columns.
    SELECT *
  3. FROM tells SQL which table to pull the data from.
    SELECT *
FROM products

Practice

Try each one in your head first, then open the answer.

1. Write a query to show all columns and rows from the orders table.
SELECT * FROM orders
2. Write a query to show all columns and rows from the products table.
SELECT * FROM products
3. Write a query to show all columns and rows from the customers table.
SELECT * FROM customers
4. Write a query to show all columns and rows from the inventory table.
SELECT * FROM inventory
5. Write a query to show all columns and rows from the returns table.
SELECT * FROM returns

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed