Skip to Main Content

Show and Tell

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to query selected multiple rows into multiple colums

Harry TiadiJan 8 2024

How to display datas using query data from multiple specific rows in one table sql into multiple columns? For example, insert red data into column1, insert blue data into column2, insert green data into column3, etc.

I've used these code : SELECT um_value FROM _wp_um_metadata_ WHERE um_key='first_name'

But the result I only got one column.

Please help if someone has expert knowledge about MySQL here. Thanks for sharing it.

Here the screenshot of example sql database :

Comments

Post Details

Added on Jan 8 2024
0 comments
272 views