Hi,
I was wondering if anyone can help with a problem I have having with SQL.
I have a table 'people' in a Sqlite database with a column 'population'.
All I
want to do is to add up all the values in this column. When the data is
in an
Excel file, the column adds up to 8,581,774.
I used the SQlite Database Browser (http://sqlitebrowser.sourceforge.net/)
to get the data into a Sqlite database and ran the following query:
SELECT SUM(population) FROM people
I am supposed to get 8,581,774 but instead I am getting 14898.38. I
exported
the data back out to a csv file and checked it in Excel and all the data
was there
adding up to 8,581,774.
So is there something wrong with my query or should the query be
different with
Sqlite?
Thanks for any advice,
Umesh Persad
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
