write a procedure to find top second no from a list of numbers

write a procedure to find top second no from a list of
numbers

Question Posted / sankarcherrala

1 Answers
4587 Views
ABC, I also Faced
E-Mail Answers

write a procedure to find top second no from a list of numbers..

Answer / 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

More SQL PLSQL Interview Questions

How to get unique records from a table?

0 Answers

What are crud methods?

0 Answers

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers

How do I count rows in sql query?

0 Answers

What is crud diagram?

0 Answers

Can we use threading in pl/sql?

0 Answers

how will i became good database developer?

1 Answers

Why do we need unique key in a table?

0 Answers

what is the difference between clustered and non clustered index in sql? : Sql dba