SQL · Array and set-returning functions

VALUES as a table

Builds an inline table without creating one. Works in PostgreSQL and SQLite.

sqlRunnable example sql course

Syntax

values (1), (2)

Example

Open in the lab

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

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