MySQL Forums
Forum List  »  Newbie

MYSQL Query Help
Posted by: Frank Lepkowski
Date: March 15, 2022 08:18AM

I have a table schema.

event_time,Val_Zone,Val_1,Val_2 (columns)

I want to return data grouped by event_time for each Val_Zone as follows

event_time,Zone1_Val_1,Zone2_Val2....... (columns)

I will have28 zone records per unique event_time.

returned records will look like this

1-1-2022 12:00:00, Zone1_Val1,Zone2_Val2......28 zones
1-2-2022 1:40:30, Zone1_Val1,Zone2_Val2......28 zones

Any help is appreciated.

Options: ReplyQuote


Subject
Written By
Posted
MYSQL Query Help
March 15, 2022 08:18AM
March 15, 2022 11:18AM
March 16, 2022 06:12AM


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.