Question { 38517 }

find the third highest salary?

Answer

select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3

Question { Intelligroup, 6845 }

how to pass 2 variables from one form to other form

Answer

Assalam-o-Alikum.
you can pass the value of two variable from form F1 to form
F2
First you have to create the two parameter on form F2 name
p1 and p2 and save the form.
then you go on to F1 and write tis code on button on text
item through which you want to send the parameter.
Declare
para ParamList;
Begin
para:=get_parameter_list('plist') /*plist can be replace by
any character*/
if not id_null(para) then
destroy_parameter_list('plist');
end if;
para:=create parameter_list('plist');
Add_Parameter(para,'P1',variable_1);
Add_Parameter(para,'P2',variable_2);
---after this you can add
call_form('F2');
--you can see the argument pass through form F1 to FORM F2.
end;

Question { TCS, 5583 }

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

Answer

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)