Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

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

Answer Attachments

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