Krishna Kumar

Krishna Kumar

  • NA
  • 135
  • 38.6k

Need Help For Grouping the Rows

Apr 18 2017 2:21 AM
Dear all,
I have a table like below
date                    bill_desc              amount
17-04-2017        RoomCharge        250.00
17-04-2017        BreakFast                80.00
17-04-2017        ExtraBed              120.00
17-04-2017       WaterBottle              30.00
Noe I want to sum the amount of Roomchage and description and display it as RoomCharge and remaining chrges are ther to be displayed.
date                       bill_desc                    amount
17-04-2017          RoomCharge           330.00 (RoomCharge + Breakfast)
17-04-2017          ExtraBed                  120.00
17-04-2017          WaterBottle              30.00
I need to group the data by date.. can anyone help me to acheive this. I have an idea that this will be acheived by case statement, But i dont know how to prepare that or you can suggest me the other method
Thank You in Advance

Answers (2)