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.
