Execution order of aggregate function in sql

Question

0.00/5 (No votes)

See more:

Order of execution of query in sql is follow according to my knowledge.

1. FROM
2. ON
3. OUTER/Inner
4. WHERE
5. GROUP BY
6. CUBE or ROLLUP
7. HAVING
8. SELECT
9. DISTINCT
10. ORDER BY
11. TOP
Can anybody tell me order of execution of aggregate function.In my select clause I have 2 aggregate function.Which one get executed first?

SQL

Select City, Gender, SUM(Salary) as TotalSalary,
COUNT(ID) as TotalEmployees
from tblEmployee
group by City, Gender

Posted 4-Nov-15 1:26am

Member 11589429

Updated 4-Nov-15 1:56am

_Asif_

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

John C Rayan · Answer 1 · 2015-11-04T01:37:00

Solution 1

Time for you to read some documentation.
https://msdn.microsoft.com/en-us/library/ms189499.aspx[^]

Posted 4-Nov-15 1:37am

John C Rayan

Comments

jaket-cp 4-Nov-15 8:31am

Can you specify where in the documentation you are referring, to answer this question.
Thanks

John C Rayan 4-Nov-15 8:57am

Hi

Despite the fact that it does not directly answer your question , Group By will give you pointer to answering to your question. Also the overall logical processing of the article would help you understand more about your answer.

jaket-cp 4-Nov-15 8:59am

Thanks for the reply - this is not my question.
I was just interested in what the solution could be, but reading the document you pointed to did not answer it for me.

John C Rayan 4-Nov-15 9:04am

Could I ask you the reason for knowing the order of the aggregate functions? If you tell use what you are trying to do then it will help us to give you the solution. There is an answer for the same question in this link

http://stackoverflow.com/questions/33521657/execution-order-of-aggregate-function-in-sql

jaket-cp 4-Nov-15 9:07am

As I said I am not the OP.
Was just interested to know the solution to the question of the OP, that is all.
Thanks :)