Is there a way to write a select statement that will create multiple rows from a string literal select statement?
Select '123' as row1 will produce a table like:
row1 |
123
Select '123' as row1, '456' as row2 will produce
row1 | row2|
123 456
My question is, what is the correct syntax to make multiple rows with the same field heading such as:
row1 |
123
456
789