On 2/8/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > Hi All, > > I have a question that I hope you can help with. I would like to know > what results other database engines (i.e. mySQL, PostgreSQL, Firebird, > Oracle, MS SQL, etc) give for the following SQL. > > create table t (a integer, b real); > insert into t values (3, 3); > insert into t values (3, 3); > insert into t values (4, 4); > select avg(a), avg(b) from t; > > In SQLite I get the following: > > SQLite version 3.3.2 > Enter ".help" for instructions > sqlite> create table t (a integer, b real); > sqlite> insert into t values (3, 3); > sqlite> insert into t values (3, 3); > sqlite> insert into t values (4, 4); > sqlite> select avg(a), avg(b) from t; > 3.33333333333333|3.33333333333333
MS SQL 2000 3 3.3333333333333335 ms access 3.33333333333333 3.33333333333333