SQL Select to return a static list of values?

Question

Is there a way to perform a select and return a static list? Something like the following:

select * from ('CA', 'FB', 'FC')

It should return

CA
FB
FC

user_10676716 · Answer

If you want each value on a separate row, you can use table constructor values():

select val
from (values ('CA'), ('FB'), ('FC')) as t(val)

user_12055479 · Answer

Perhaps:

select 'CA'
union all
select 'FB'
union all
select 'FC'