Skip to content

Choosing columns

SQL · Free lesson · No account needed

Step 1 of 9 · Start here

Choosing columns

Start here

List the columns you want after SELECT, with commas between them. They come back in the order you list them.

You can also calculate a column, and name it with AS:

SELECT title, price * stock AS stock_value FROM books;

You’re trying a free lesson. Your progress saves on this device. Create a free account to keep it everywhere and ask the AI tutor.