KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Suppose my table contains the following: ID price ------------- 1 10 1 10 2 20 2 20 3 30 3 30 Each time through a while loop. I want to get the sum of the values on price but only once for every distinct value in ID So given the example above, I would arrive with something like: ID price ------------- 1 20 2 40 3 60 Just to add, I may have stumble upon a post with a similar inquiry. Problem is that other post uses Oracle, I on the other hand am using MySQL.
Tags (comma-separated)
Save Edits
Cancel