Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
I need Time Wise summary Report in mysql
snowal raj
7y
276
1
Reply
hai,
I have some data like
Date
Amount
30-01-2017 19:07:46
10
30-01-2017 19:08:52
20
30-01-2017 19:15:10
65
30-01-2017 19:16:58
85
30-01-2017 19:17:13
48
30-01-2017 19:20:05
165
30-01-2017 19:20:29
15
30-01-2017 19:38:53
98
30-01-2017 19:40:15
35
31-01-2017 21:45:18
56
31-01-2017 21:46:22
58
31-01-2017 22:05:27
12
31-01-2017 23:54:49
5
31-01-2017 23:55:53
84
31-01-2017 23:56:49
41
31-01-2017 23:59:01
65
And I need result using mysql in this format
Time Intervel
Amount
19:00:00-20:00:00
541
20:00:00-21:00:00
0
21:00:00-22:00:00
114
22:00:00-23:00:00
12
23:00:0-00:00:00
195
Please Help,
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
write select stmt using linq
How to get time wise sales report in mysql