| |

VerySource

 Forgot password?
 Register
Search
View: 837|Reply: 3

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

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 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

Newbie

Rank: 1

Credits
69.00

 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

Newbie

Rank: 1

Credits
73.00

 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

Newbie

Rank: 1

Credits
73.00

 China

Post time: 2020-5-2 20:00:01
| Show all posts
Ha ha. . Upstairs is really fast
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

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

Quick Reply To Top Return to the list