Group functions in oracle

Description of group functions in oracle: This article introduces considerations for count, sum, avg, max, and min 1. count does not calculate null values www.2cto.com 2, and single row functions (coalesce, nvl, to_char, to_date) is different. The single-row function returns a row of results for each row of data, and the group function returns a row of result 3 for multiple rows of data. If the column name is written in the function, null value 4 is ignored by default, avg/sum is used for numeric operations 5. max/min can be used for all data types.