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
- 4495 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 |
More SQL PLSQL Interview Questions
What does the sign mean in sql?
Delete the emps whose salaries are lowest sals of their own dept.
What is AUTH_ID and AUTH_USER in pl/sql ?
What is sql rowcount?
How to sort the rows in sql.
How can we optimize a sql query?
What is package in pl sql with an examples?
How do you delete a table?
What are the indexing methods?
What does seeding a database mean?
What is rownum and rowid?
What is package in pl sql?
Categories
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
