Home > database >  Ask a question of db2 columns turned
Ask a question of db2 columns turned

Time:09-19

Assume the table test

Before the transformation:
Col1 col2
-- -- -- -- -- -- -- -- -- -- -- --
1 a
2 b
3 c
4 d
5 e
. .

Want to convert:
Col1 col2 col3 col4 col5...
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
1 2 3 4 5...
A b c d e...

Could you tell me how to achieve with db2?

CodePudding user response:

Why can't see their release in the list of posts?
  •  Tags:  
  • DB2
  • Related