This lesson's interactive features are locked, please to keep using them
Select Single Column
Databases are made up of tables which are made up of columns (AKA "fields"). It's just like an Excel spreadsheet.
Each row in a table is a single record. For example, here are three rows from our CashPal users table:
| id | name | age | balance | is_admin |
|---|---|---|---|---|
| 1 | John Smith | 28 | 450 | 1 |
| 2 | Darren Walker | 27 | 200 | 1 |
| 3 | Jane Morris | 33 | 496.24 | 0 |
In the last lesson, we used the * wildcard to get all the columns. To select only a single column, swap out the * for the name of the specific column:
SELECT
name
FROM
users;
Assignment
Update the query to only select the age column from the users table.