I am trying to get the sum of particular field. I am getting the SUM wrong when I try to get the values together.
I have this:
reference: id_skill, user, level_paid
More specifically the table reference as:
id_skill | user | level_paid |
---|---|---|
100 | Red | 1 |
100 | Red | 1 |
200 | Red | 2 |
200 | Red | 1 |
What I want as a result from my query is,
id_skill | user | level_paid |
---|---|---|
100 | Red | 2 |
200 | Red | 3 |
SELECT
SUM(level_paid) AS total,
FROM reference
WHERE user = 'Red'
GROUP BY
id_skill
What I am trying to achieve is to get the sum of the field "level_paid" if the records of "id_skill" is more than 1.
2
Answers
You can achieve the result with the following query. The
HAVING
clause will ensure, you are only summing the values, which are more than 1 records, based on theGROUP BY
condition e.g. at least twoid_skill
with the same value.I think
The issue is if you want to print id_skill , and users too you need to update your query to
also i have also noticed that there is an extra comma in your query before from also remove that extra comma