answersLogoWhite

0

Aggregate functions:

COUNT, SUM, MIN, MAX, AVG

NOTE: It can be used only in the SELECT list and in the HAVING clause. Using it anywhere else will be incorrect; also you cannot nest aggregate functions.

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

RossRoss
Every question is just a happy little opportunity.
Chat with Ross
FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin

Add your answer:

Earn +20 pts
Q: What restrictions apply to the use of aggregate function within the select?
Write your answer...
Submit
Still have questions?
magnify glass
imp