This repository has been archived by the owner on Oct 16, 2021. It is now read-only.

[feature] implement window functions #30

Open

BohuTANG opened this issue Feb 15, 2020 · 0 comments

Labels

P1 type: feature

Contributor

BohuTANG commented Feb 15, 2020

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

The text was updated successfully, but these errors were encountered:

BohuTANG added type: feature P1 labels

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.