Query Quest PostgreSQL Course

Choose columns

SELECT reads rows from a table. An asterisk means every column, but naming columns makes the output focused and usually cheaper to transfer.

What you'll learn

The columns after SELECT appear in the order you write them. FROM names the table.

Your mission

Show only the username and xp columns from players.

Enable JavaScript to run SQL in the interactive lesson.