[feature] implement window functions
BohuTANG opened this issue · 0 comments
BohuTANG commented
Summary
implement window functions
SELECT
EmpName,
DeptName,
SUM(Salary) OVER( PARTITION BY DeptName ) AS SalaryByDept
FROM @employees;
EmpName | DeptName | SalaryByDept |
---|---|---|
Noah | Engineering | 60000 |
Sophia | Engineering | 60000 |
Liam | Engineering | 60000 |
Mason | Executive | 50000 |
Emma | HR | 30000 |
Jacob | HR | 30000 |
Olivia | HR | 30000 |
Ava | Marketing | 25000 |
Ethan | Marketing | 25000 |