Computer Science
SUM, AVG, MIN, and MAX can only be used with numeric columns.
SQL Joins & Grouping
1 Like
Answer
True
Reason — The aggregate functions SUM, AVG, MIN, and MAX are designed to work with numeric columns in SQL. They expect numeric values as arguments and return numeric results.
Answered By
1 Like
Related Questions
Missing join condition in join query produces cartesian product.
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
The HAVING and WHERE clauses are interchangeable.