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
- 4404 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
Can a foreign key be null?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is bind reference and how can it be created?
What is an intersect?
What is cartesian join in sql?
How do I view a procedure in sql?
Can there be 2 primary keys in a table?
What is example of database?
How to take user input in pl sql?
What is the syntax to add a record to a table?
What do you understand by pl/sql packages?
What is trigger and stored procedure in sql?
who introduced sql?
Can we create a trigger on view?
Define SQL and state the differences between SQL and other conventional programming Languages?
