How to convert rows columns in db2 sql

sandhyaimmadi · New User Joined: 18 Aug 2008 Posts: 50 Location: Bangalore

Hi,

I need the query which is used to convert rows into columns.
I have tried with ROW_NUMBER() OVER(PARTITION BY USERID ORDER BY USERID) R function,but it is not working.
Could you please let me know if any other alternative is there.

Thanks in advance.
Sandhya

dick scherrer · Posted: Fri Aug 29, 2008 12:30 am

Hello Sandhya and welcome to the forums,

Please post example data of some rows in a table and the data you want for output from these rows. This does not need to be a large volume, but should be enough to show what you want to do.

When posting data, it is best to use the "Code" tag near the top of the reply panel as it makes your post much more readable. You can also "Preview" your post and see how it will appear to the forum and then click "Submit" when you are satisfied with how your post appears.