1
Answer

Pivot with date and sum without case statements

Sai Reddy

Sai Reddy

5y
452
1
I have a table with product, date, amount
 
I need the output as follows.
 
Product,date1,date2,date3,date4
1,1000,2000,3999,3333
 
Please help me solve it in mysql without case statement
Answers (1)