write a procedure to find top second no from a list of
numbers
Answer Posted / roshan
create or replace procedure pr_getmax(enter_number in
number,sal out number)
as
begin
select salary into sal from
(select rownum rn,salary
from
(select
a.salary
from
employees a
order by a.salary desc) )a
where
a.rn = enter_number;
end;
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why join is faster than subquery?
What is a sql trace file?
What is the maximum size of sqlite database?
How do I save a sql query?
Does google use sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is rank () in sql?
how can we know the count/number of elements of an array? : Sql dba
How to set up sql*plus output format in oracle?
How bulk collect improves performance?
What do you mean by stored procedures? How do we use it?
how are mysql timestamps seen to a user? : Sql dba
What are sql built in functions?
Why is %isopen always false for an implicit cursor?
Define commit?