I create table with this sql:
CREATE TABLE table1 (int id);

and fill with some randomize values

I try this sql:
SELECT SUM(id) FROM table1

to sum the table rows but its return error
no such column: id


i use the sqlite from a c++ code
with this function
sqlite3_get_table();



thanks.

-- 
View this message in context: 
http://www.nabble.com/cant-sum-rows-tf2915362.html#a8146664
Sent from the SQLite mailing list archive at Nabble.com.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to