Skip to content
Advertisement

SQL | I want to compare a sum of two or more rows and then make a select statement

So I have this table in MySQL:

datec.masini

enter image description here

So, a proprietar (person unique ID) can have one or more cars with a valoare (value $) and I want to show by a SELECT statement all the persons (proprietar) with cars above 190000$. I tried this but doesn’t work:

SELECT proprietar FROM datec.masini WHERE sum(valoare)>190000

and I want this result:

1990724 5780623

What am I missing here?

Advertisement

Answer

One approach, using aggregation:

SELECT proprietar
FROM datec.masini
GROUP BY proprietar
HAVING SUM(valoare) > 190000;
2 People found this is helpful
Advertisement