SQL · Reading data

select *

Returns every column. Convenient in exploration, risky in production because schema changes leak into results.

sqlRunnable example sql course

Syntax

select * from table;

Example

Open in the lab

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

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