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;

What is file based approach?

942

---

how to get @@error and @@rowcount at the same time? : Sql dba

1028

---

What is rename in sql?

975

---

What is the difference between microsoft access and sql?

1024

---

What is the location of pre_defined_functions.

1166

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

---

How do I run a sql query?

1023

---

Explain what is a column in a table?

1107

---

What sql does db2 use?

983

---

what are wild cards used in database for pattern matching ? : Sql dba

1144

---

What view means?

980

---

Describe types of sql statements?

1059

---

how many values can the set function of mysql take? : Sql dba

989

---

what is an alias command? : Sql dba

1116

---

What is trigger in sql?

1101

---