《oracle教课件》尚硅谷_宋红康_05_分组函数.pptVIP

Group Functions (continued) You can use the MAX and MIN functions for any data type. The slide example displays the most junior and most senior employee. The following example displays the employee last name that is first and the employee last name that is the last in an alphabetized list of all employees. SELECT MIN(last_name), MAX(last_name) FROM employees; Note: AVG, SUM, VARIANCE, and STDDEV functions can be used only with numeric data types. The COUNT Function The COUNT function has three formats: COUNT(*) COUNT(expr) COUNT(DISTINCT expr) COUNT(*) returns the number of ro