What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?

      

What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?

  

Answers


kelvin
An aggregate function can be used only in the SELECT list and in the HAVING clause.Apart from COUNT(*), each function eliminates nulls first and operates only on the remaining non-null values. COUNT(*) counts all the rows of a table, regardless of whether nulls or duplicate values occur.

kevowmuchiri answered the question on July 4, 2018 at 15:41


Next: Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses? a)FROM b) WHERE c)GROUP BY d)HAVING e)SELECT
Previous: Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions