TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Krishna Kumar
NA
135
38.4k
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
Reply
Answers (
2
)
Database Diagram
shop booking management system erd