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
Novice
Re: QT SQL advice
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
Running:
RHEL 5.4
Python 2.7.2
Qt 4.7.4
SIP 4.7.8
PyQt 4.7
Posting Permissions
Reply With Quote
Bookmarks