SQL output convert columns to rows

Question

I am running the following SQL query:

select distinct col + "abc" value1, col+ "xyz" value2
from table_name
where col = "1234567890"

This returns output as:

value1        value2
1234567890abc 1234567890xyz

But I want the output as:

value
1234567890abc
1234567890xyz

How can I do this?

Fahmi · Accepted Answer · 2019-07-17 07:56:25Z

1

use union all

select distinct col + "abc" value
from table_name
where col = "1234567890"
union all
select distinct col+ "xyz" 
from table_name
where col = "1234567890"

answered Jul 17, 2019 at 7:56

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Fahmi Over a year ago

You accepted the answer, but why someone downvoted me? that's a question :)

Ankur Over a year ago

Not sure who downvoted, but I just upvoted your answer. Thanks :)

Zaynul Abadin Tuhin · Accepted Answer · 2019-07-17 07:56:37Z

0

use concat and union all

select concat(col, 'abc') value1
from table_name
where col = '1234567890'
union all
select concat(col, 'xyz')
from table_name
where col = '1234567890'

answered Jul 17, 2019 at 7:56

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

Collectives™ on Stack Overflow

SQL output convert columns to rows

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related