sum(population) under Sybase

> Just to add in here...Oracle:
>
> SQL> select sum(population) from nations;
>
> SUM(POPULATION)
> ---------------
> 2771277000
>
> SQL>

Here is Sybase. Note, I declared the population field as int.

1> SELECT * FROM t1
2> go
name population
-------------------- -----------
RUSSIA 281170000
INDIA 766140000
CHINA 1072220000
JAPAN 129947000
CANADA 25610000
U.S.A. 242080000
MEXICO 81160000
BRAZIL 141450000
ARGENTINA 31500000

(9 rows affected)
1> select sum(population) from t1
2> go
Arithmetic overflow occurred.

But with population defined as numeric(20,0)

1> select * from t2
2> go
name population
-------------------- -----------------------
JAPAN 129947000
CANADA 25610000
U.S.A. 242080000
MEXICO 81160000
BRAZIL 141450000
ARGENTINA 31500000
INDIA 766140000
CHINA 1072220000
RUSSIA 281170000

(9 rows affected)
1> select sum(population) from t2
2> go

-----------------------------------------
2771277000

I sort of like this behavior. This way, a valid sum over fields of
type X can always be stored in a field of type X.

Ocie Mitchell