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

Answer / mukesh

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

Answer / niru

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

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)

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,

---

What are triggers?Where are they used?

3 Answers  

---

Difference between inner join vs where ?

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

Is oracle a relational database?

0 Answers  

---

What is a synonym? What are its various types?

0 Answers  

---

How to create a testing table in oracle?

0 Answers  

---

How to run create database statement?

0 Answers  

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---

Explain the family trees and connection by clause

0 Answers  

---

How to create a stored function in oracle?

0 Answers  

---