Choose Your Columns
Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 2 of 20.
A product row has several attributes. Selecting only the columns needed for a question makes the result easier to read. Put their names after SELECT, separated by commas.
Input table products:
id | name | category | price | stock | active | note |
|---|---|---|---|---|---|---|
1 | Map | travel | 12 | 5 | True | NULL |
2 | Notebook | books | 8 | 0 | True | Recycled |
3 | Atlas | books | 24 | 3 | False | NULL |
4 | Mug | home | 12 | 8 | True | Blue |
5 | lamp | home | 30 | 2 | False | Clearance |
6 | Mini map | travel | 6 | 10 | True | NULL |
SELECT name, stock FROM products;The result has two columns: name followed by stock. For the Map row these are Map and 5. Listing columns chooses their output order; it does not rearrange the stored table.
List output columns after SELECT and the source table after FROM. SELECT * reads all columns.
Challenge
EasyThe stock team needs product identifiers and quantities. Return id and stock, in that column order, for every product. Row order does not matter yet.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in First Queries
Practice on your own: PostgreSQL playground