Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
how to calculate sum for every 5 rows in sql
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
nag k
9y
671
1
Reply
hi iam new to sql Database.i have a problem my table is like this
id |name| | amount
---------------------
1 | xyz | 15
2 | xyz | 54
3 | xyz | 787
2 | xyz | 455
3 | hhh | 58
3 | hhh | 789
3 | hhh | 478
3 | hhh | 7855
and i want result like this .
id |name| | amount
---------------------
1 | xyz | 15
2 | xyz | 54
3 | xyz | 787
4 | xyz | 455
-----------
toatal 1311
-----------
5 | hhh | 58
6 | hhh | 789
7 | hhh | 478
8 | hhh | 7855
-----------
toatal 9180
-----------
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Table in SQL
get 1column thrice time on diffrent cond. from same table.