Answer Posted / kishore

select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1064

---

what is bdb (berkeleydb)? : Sql dba

1035

---

What is sqlite format?

1200

---

What version is sql?

1035

---

how to return query output in html format? : Sql dba

1074

---

How do I remove duplicates in two columns?

1067

---

How do you use collections in procedure to return the resultset?

2238

---

which operator is used in query for pattern matching? : Sql dba

1007

---

What are local and global Indexes and where they are useful.

1444

---

Is left join same as join?

997

---

What is cursor explain with example?

987

---

What is sql in java?

1090

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1016

---

What is the maximum size of sqlite database?

1112

---