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
- 4499 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 |
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question
How does one load ebcdic data? : aql loader
What is query optimization in sql?
How do I send sql query results to excel?
What are the different sql commands?
What are the different types of constraints?
What is constant in pl sql?
How much does sql cost?
how do you know the version of your mysql server? : Sql dba
When can we use the where clause and the having clause?
what is pragma ?
What is a left inner join?
-
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)
