We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

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:

idnameagebalanceis_admin
1John Smith284501
2Darren Walker272001
3Jane Morris33496.240

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.