If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
SELECT EMPLOYEE_ID, (CONTRIBUTION / SUM (CONTRIBUTION) OVER (PARTITION BY FAMILY ID) ) * 100 || % AS EXPECTED_VALUE FROM FAMILY;

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
SELECT B.ID,(B.CONTRIBUTION/A.CONTRIB)*100||% AS EXPECTED VALUE FROM
(SELECT FAMILY_ID,SUM(CONTRIBUTION) FROM FAMILY
GROUP BY FAMILY_ID) A, FAMILY B
WHERE A.FAMILY_ID=B.FAMILY_ID

Answer Question  Select Best Answer