SQL · Reading data

column alias

Renames an output column. Quote aliases that contain spaces.

sqlRunnable example sql course

Syntax

select minutes * 60 as seconds

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (12))
SELECT minutes * 60 AS seconds FROM lessons;

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