QT SQL advice

[Lesiok]

I just remembered the "Group By" sql argument.
so I think I can just do:
SELECT SUM(value) FROM database WHERE group=x AND (range > y AND range < z) GROUP BY id

Of course but I think that it should looks like :

SELECT id, SUM(value) FROM database WHERE group=x AND (range > y AND range < z) GROUP BY id

SELECT id, SUM(value) FROM database WHERE group=x AND (range > y AND range < z) GROUP BY id

To copy to clipboard, switch view to plain text mode 

Without it you will not know what is the id of the sum.