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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is oracle and what are its different editions?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Can we insert data in view oracle?
How to recover a dropped index?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain the use of file option in exp command.
How you open and close a cursor variable.Why it is required?
Explain temporal data types in oracle
Explain the dml?
Will you be able to store pictures in the database?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?