SQL select dummy data

Question

I have attempted to create some dummy data from a select statement. I can easily create 1 column with 1 dummy data, or 2 columns with 1 dummy data, but how can I go about making 1 column with 2 dummy data(2 rows)?

(No column name)
    dummy1
    dummy2

Select statements that are 1 dummy data per column:

Select 'dummy'

Select 'dummy1','dummy2'

Answer 1

Just another option with one or multiple columns

Single Column

Select *
 From  (values ('Dummy1')
              ,('Dummy2')
       ) A(Dummies)

Returns

Dummies
Dummy1
Dummy2

Multiple Columns

Select *
 From  (values ('Dummy1',1)
              ,('Dummy2',2)
       ) A(Dummies,Value)

Returns

Dummies Value
Dummy1  1
Dummy2  2