分组集（SQL Server 2008） [英] Grouping Sets in (SQL Server 2008)

问题描述

这是我的查询...

Hi,

This is my Query...

SELECT Region, Department, avg(sal) Average_Salary
from tbl_Employee
GROUPING SETS
      (
            (Region, Department),
            (Region),
            (Department) ,
            ()
      )

我在sql server 2008中运行此查询但显示错误...

'SETS'附近的语法不正确。< br $> b $ b



请帮帮我。

I have run this query in sql server 2008 but showing error ...
Incorrect syntax near 'SETS'.


Please help me any one.

推荐答案

尝试使用

Try using

SELECT Region, Department, avg(sal) Average_Salary
from tbl_Employee
group by GROUPING SETS
      (
            (Region, Department),
            (Region),
            (Department) ,
            ()
      )

这篇关于分组集（SQL Server 2008）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！