MySQL Forums
Forum List  »  MySQL Workbench

Pivot without aggregate or similar function?
Posted by: John Marchbanks
Date: July 15, 2022 02:07PM

Have:

Date Type Value
3/3/22 12:09 Apples 43
7/19/21 18:19 Oranges 25
3/3/22 12:09 Oranges 53
7/19/21 18:19 Apples 23

Need:

Date Apples Value Oranges Value
3/3/22 12:09 43 53
7/19/21 18:19 23 25

Extremely grateful to anyone who can help me figure this out in SQL WorkbenchJ!

Options: ReplyQuote


Subject
Views
Written By
Posted
Pivot without aggregate or similar function?
235
July 15, 2022 02:07PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.