sql query for select multiple columns in single column

shubham upadhyay

6y2.8kSQL

i have one single table and in that table there are three columns company1,company2,company3.

below is my table data :

Hide Copy Code

Company1 Company2 Company3

ABC

Test1 Test3 Test5

Test2 Test4 Test6

testing testing2

and i want to combine these columns into single column with serial number like below :

Hide Copy Code

SrNo CompanyName

1 ABC

2 Test1

3 Test2

4 testing

5 Test3

6 Test4

7 testing2

8 Test5

9 Test6

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
Along with Union/Union All you need to use Row_number() to get the SrNo.

select row_number(), company from (
select Company1 as company from table
union
select Company2 from table
union
select Company3 from table ) atable
Santhakumar Munuswamy6y ago
Hi Shubham,

I hope, you have found solutions or resolved your queries. it is really helpful to resolve your queries then you can mark as Answer. it will help others.

Thanks
Farhan Ahmed6y ago
https://support.microsoft.com/en-us/office/use-a-union-query-to-combine-multiple-queries-into-a-single-result-1f772ec0-cc73-474d-ab10-ad0a75541c6e?ui=en-us&rs=en-us&ad=us https://www.codeproject.com/Questions/1072449/combine-multiple-columns-in-to-single-columns-in-s
Santhakumar Munuswamy6y ago
Hi Shubham,

Yes, we can use the UNPIVOT function or Union to get your expecting result. you can check out the link

Union All:

https://blog.sqlauthority.com/2014/05/30/sql-server-merge-two-columns-into-a-single-column/

UNPIVOT function:

https://stackoverflow.com/questions/19515829/select-values-from-multiple-columns-into-single-column

https://stackoverflow.com/questions/49933293/how-to-combine-multiple-columns-into-one-column

https://www.codeproject.com/Questions/1072449/combine-multiple-columns-in-to-single-columns-in-s

I hope it will be helpful to you

Thanks