Interested to Buy Any Domain ? << Click Here >> for more details...
write a procedure to find top second no from a list of
numbers
- 1 Answers
- 4585 Views
- ABC, I also Faced
- E-Mail Answers
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
Should I use mbr or gpt?
What is pivot table in sql?
What are the two types of exceptions in pl/sql?
Explain spool.
What is clause?
How to avoid using cursors?
How to write pl sql program in mysql command prompt?
How to pronounce postgresql?
how to use case expression? : Sql dba
What is meant by <> in sql?
Is left join and outer join same?
What are the types of sql commands?
What are database links used for?
How to run sql statements with oracle sql developer?
How delete all data from all tables in sql?
