如何在SQL CTE表达式中解析 [英] how to resolve in SQL CTE expression

问题描述

  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!
:)

这篇关于如何在SQL CTE表达式中解析的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！