sql中聚合函数的执行顺序 [英] Execution order of aggregate function in sql

问题描述

根据我的知识，在sql中执行查询的顺序。



1. FROM

2. ON

3. OUTER / Inner

4. WHERE

5. GROUP BY

6. CUBE或ROLLUP

7. HAVING

8.选择

9. DISTINCT

10.订购

11 TOP

任何人都可以告诉我聚合函数的执行顺序。在我的select子句中我有2个聚合函数。首先执行哪一个？

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?

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

推荐答案

您有时间阅读一些文档。

https://msdn.microsoft.com/en-us/library/ms189499.aspx [ ^ ]

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

这篇关于sql中聚合函数的执行顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！