Share this page

Aggregate Functions and Decimal Data

Given decimal arguments, aggregate functions (with the exception of count) return decimal results.

The following table explains how to determine the scale and precision of results returned for aggregates with decimal arguments:

Name | Precision of Result | Scale of Result |

count | Not applicable | Not applicable |

sum | 39 | Same as argument |

avg | 39 | Scale of argument + 1 (to a maximum of 39) |

max | Same as argument | Same as argument |

min | Same as argument | Same as argument |