MySQL Forums
Forum List  »  Newbie

Transpose ROW to COLUMN
Posted by: pompilio solazzo
Date: February 22, 2016 09:16AM

HI, I have a big problem.

I need to transpose the table rows into columns.
The number of lines changes.
What is a dynamic query or procedure to do this?
The number of the result columns changes.


DAY user app num_events duration volume
2015-10-01 00 pippo facebook 1 44 2037
2015-10-01 00 pippo youtube 9 984 48256
2015-10-01 00 pippo whatsapp 1 28 3
2015-10-01 01 pippo youtube 1 531 24306
2015-10-01 12 pippo facebook 1 925 41762

TNKS
ILIO

Options: ReplyQuote


Subject
Written By
Posted
February 22, 2016 09:08AM
Transpose ROW to COLUMN
February 22, 2016 09:16AM
February 22, 2016 11:11AM


Sorry, you can't reply to this topic. It has been closed.

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.