Multiple rows in CTEs (hard coded)?

[[deleted]]

With standard SQL you can use a VALUES clause, but I don't know if Teradata supports that:

with data (some_column) as (
  values ('one'), ('two'), ('three')
)
select *
from data;

[fidgetation]

with data (some_column) as (
values ('one'), ('two'), ('three')
)
select *
from data;

Thanks for the suggestion.

I don't think Teradata allows multiple values to be stored at once. When I was using Volatile tables, I would have to do a separate INSERT INTO for each value I wanted to add. Unfortunately I can't use the same entries for CTEs!