> ## Documentation Index
> Fetch the complete documentation index at: https://docs.upsolve.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# VALUES

## Synopsis

```sql theme={null}
VALUES row [, ...]
```

where `row` is a single expression or

```sql theme={null}
( column_expression [, ...] )
```

## Description

Defines a literal inline table.

`VALUES` can be used anywhere a query can be used (e.g., the `FROM` clause
of a [SELECT](/sql/reference/select), or at the top level). `VALUES` creates
an anonymous table without column names, but the table and columns can be named
using an `AS` clause with column aliases.

## Examples

Return a table with one column and three rows:

```sql theme={null}
VALUES 1, 2, 3
```

Return a table with two columns and three rows:

```sql theme={null}
VALUES
    (1, 'a'),
    (2, 'b'),
    (3, 'c')
```

Return table with column `id` and `name`:

```sql theme={null}
SELECT * FROM (
    VALUES
        (1, 'a'),
        (2, 'b'),
        (3, 'c')
) AS t (id, name)
```

Create a new table with column `id` and `name`:

```sql theme={null}
CREATE TABLE example AS
SELECT * FROM (
    VALUES
        (1, 'a'),
        (2, 'b'),
        (3, 'c')
) AS t (id, name)
```

## See also

[SELECT](/sql/reference/select)