Hi, What do other database do?
Regards, Thomas Am 10.09.2013 15:58 schrieb "Cecil Westerhof" <[email protected]>: > When AVG is used on a column that has INT data, the result is an INT. > Would it not be better to cast it to a DOUBLE? Now I need to do something > like: > ROUND(AVG(CAST(total AS DOUBLE)), 2) AS avg, > > At the same time it would be nice to have the possibility to give the > number of digits behind the dot. So that the above would become: > AVG(total, 2) AS avg, > > I find this a lot neater. > > -- > Cecil Westerhof > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
