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
What are string functions in sql?
How do you sort in sql?
What is a ddl command?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How do you exit in sql?
Can we insert in sql function?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is sql basics?
Is inner join same as self join?
What is full form of rtm?
What are synonyms in sql?
What are sql queries used for?
What is data control language (dcl)?
what is the command line end user interface - mysql? : Sql dba
What is example of database?