SQL · Reading data

select

Chooses the columns returned by a query. Prefer explicit columns over select * in application code.

sqlRunnable example sql course

Syntax

select columns from table;

Example

Open in the lab

WITH lessons(title, minutes) AS (VALUES ('HTML', 12), ('CSS', 18))
SELECT title, minutes FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.