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
- 4591 Views
- ABC, I also Faced
- E-Mail Answers
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 |
Do we need to create index on primary key?
how to use myisamchk to check or repair myisam tables? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is sql*loader and what is it used for?
differentiate between float and double. : Sql dba
Is and as keyword in pl sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How many rows can sqlite handle?
Explain how to use transactions efficiently : transact sql
How global cursor can be declare with dynamic trigger ?
Is clustered index a primary key?
What are the ways on commenting in a pl/sql code?
-
Oracle (3253) - 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)
