CODE EMP_OP E1 E2 1 200000 2000 2000 1 377209 2371 2134 2 190159 2248 2024 2 254707 0 1848 3 969704 5000 5000
CODE EMP_OP EmpContribution(E1+E2) 1 577209 8505 2 444866 6120 3 969704 10000
SELECT CODE, SUM(EMP_OP) AS EMP_OP, SUM(E1) + SUM(E2) AS EmpContribution FROM TableName GROUP BY CODE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)