write sql query following source are EmpID, Salary 101 1000 102 2000 103

write sql query following source are
EmpID, Salary
101 1000
102 2000
103 3000
I want the output format like following
empid,sal,composite_sal
101 1000 1000
102 2000 3000
103 3000 6000

Question Posted / dinesh panner selvam

4 Answers
7018 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 ..

Answer / bijaylaxmi sahoo

write sql query following source are
table name-emp_det
EmpID, Salary
101 1000
102 2000
103 3000
answer-
select t.empid,t.sal,(select sum(x.sal) from emp_det x
where x.empid<=t.empid) as com_sal
from emp_det t;
output-
empid,sal,composite_sal
101 1000 1000
102 2000 3000
103 3000 6000

Is This Answer Correct ?

9 Yes

1 No

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 ..

Answer / mukesh

select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from source

Is This Answer Correct ?

3 Yes

0 No

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 ..

Answer / niru

select empid,sal,sal+lead(nvl(sal,0) from emp_det

Is This Answer Correct ?

0 Yes

0 No

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 ..

Answer / farrukh shaikh

select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from (select 101 EmpID, 1000
Salary
from dual
union all
select 102, 2000
from dual
union all
select 103, 3000
from dual
union all
select 110, 5000 from dual)

Is This Answer Correct ?

0 Yes

1 No

Post New Answer