sql-server - SQL Server 2012 中的 OVER 子句

Question

我有这个数据：

Empid   Designation         
------------------------------------
17791   Assistant Manager   
19624   Assistant Manager   
19624   Assistant Manager   
19748   Assistant Manager   
19758   Graduate Engineer Trainee   

我想要输出如下：

Designation             Count
------------------------------
Assistant Manager         4
Graduate Engineer Trainee 1

请建议我们如何在没有子查询的情况下获得它

谢谢

标签： sql-servertsql

Answer 1

看起来像一个非常简单的分组操作 - 这个怎么样：

SELECT
    Designation, COUNT(*)
FROM
    dbo.YourTableNameHere
GROUP BY
    Designation