Sai Reddy

Sai Reddy

  • 1.6k
  • 201
  • 9.6k

Pivot with date and sum without case statements

Sep 12 2019 5:34 AM
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)