skip to Main Content

MySQL Pivot Using Date As Value

I try to create a procedure that transforms the following table from: ID Visit Date 1234567 Cake 01.01.2023 1234567 Coffee 01.01.2023 1234567 Cake 02.01.2023 2345678 Coffee 02.02.2023 2345678 Coffee 03.02.2023 to: ID Cake Coffee 1234567 Max(Date) 02.01.2023 Max(Date) 01.01.2023 2345678…

VIEW QUESTION
Back To Top
Search