SQL Query that returns static values into rows instead of columns

Question

I would like query like

SELECT 'FOO1', 'FOO2'

But returns the resultset into rows instead of columns

Could you expand on your question please. What data do you get back and what data did you expect to get back? — Matt Asbury, Jan 06 '11 at 10:17

score 7 · Accepted Answer · answered Jan 06 '11 at 10:16

7

SELECT 'FOO1' as foo
UNION ALL
SELECT 'FOO2' as foo

answered Jan 06 '11 at 10:16

Mitch Wheat

score 0 · Answer 2 · edited May 23 '17 at 12:30

0

edited May 23 '17 at 12:30

Community

answered Jan 06 '11 at 11:50

jimjim

2 Answers2