i am printing to the screen a table from my dB how do i make in the last line the sum of each col ? thanks in advance peleg
SELECT blah, bleh, sum(column) as total FROM table [GROUP BY id]
pretty sure you gotta use group by for this unless you only want the sum.... just use the column that is the primary key for the group by