如何在SQL CTE表达式中解析

本文介绍了如何在SQL CTE表达式中解析的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

with Groupedsalary（DepartmentId，totalEmp） as （ 选择 DepartmentId，SUM（薪水） as Tsalary 来自 tblEmployee group by DepartmentId ）

i在输入上述状态后收到以下错误。 '）'附近的语法不正确。

解决方案

Cte表需要在声明后选择表格。

lang =sql> with Groupedsalary（DepartmentId，totalEmp） as （选择DepartmentId，SUM（薪水）作为Tsalary 来自tblEmployee group by DepartmentId ） select * from Groupedsalary

; Groupedsalary as （ 选择 DepartmentId，SUM（薪水）作为 Tsalary 来自 tblEmployee group by DepartmentId ） select * 来自 Groupedsalary

快乐编码！ ：）

with Groupedsalary(DepartmentId , totalEmp) as ( select DepartmentId , SUM(salary) as Tsalary from tblEmployee group by DepartmentId )

i am getting below error after typing above state ment. Incorrect syntax near ')'.

解决方案

Cte table requires select of table after its declaration.

lang="sql">with Groupedsalary(DepartmentId , totalEmp) as ( select DepartmentId , SUM(salary) as Tsalary from tblEmployee group by DepartmentId ) select * from Groupedsalary

Hi,

; with Groupedsalary as ( select DepartmentId , SUM(salary) as Tsalary from tblEmployee group by DepartmentId ) select * from Groupedsalary

Happy Coding! :)