|

|

VerySource»Forum › Database › MS-SQL Server › I want to combine columns a, b, and c into a single ...

Return to list New

View: 839|Reply: 3

I want to combine columns a, b, and c into a single column.

1 Threads	1 Posts	2.00 Credits

Rank: 1

Credits: 2.00

Send PM

Unknown

Post time: 2020-2-22 02:30:02
| Show all posts |Read mode

I want to combine columns a, b, and c into a single column.

Reply

Use magic Report

我是杀人狂

0 Threads	114 Posts	69.00 Credits

Rank: 1

Credits: 69.00

Send PM

China

Post time: 2020-5-2 17:00:01
| Show all posts

select a from tablename
union all
select b as a from tablename
union all
select c as a from tablename

Reply

Use magic Report

0 Threads	126 Posts	73.00 Credits

Rank: 1

Credits: 73.00

Send PM

China

Post time: 2020-5-2 18:45:02
| Show all posts

Use UNION (ALL)

SELECT A FROM ...
UNION ALL SELECT B FROM ...
UNION ALL SELECT C FROM ...

Reply

Use magic Report

0 Threads	126 Posts	73.00 Credits

Rank: 1

Credits: 73.00

Send PM

China

Post time: 2020-5-2 20:00:01
| Show all posts

Ha ha. . Upstairs is really fast

Reply

Use magic Report

Return to list New

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list