Answer Posted / yash goyal

Select slary from
(select salary from empolyees
order by salary desc
where rownum<=&no.)
order by salary Asc
where rownum=1;

What is a database trigger?

1077

---

Can pl sql procedure have a return statement?

1035

---

Compare sql & pl/sql

1145

---

What packages are available to pl/sql developers?

1070

---

Give the order of sql select?

1143

---

Does pl/sql support create command?

1124

---

How do I send sql query results to excel?

1076

---

Does user triggers have entry for trigger with compilation errors?

1045

---

What is difference between left and right outer join?

995

---

Is sql pronounced sequel or sql?

1278

---

Explain the insert into statements in sql?

1013

---

What is type and rowtype in pl sql?

1021

---

how to convert dates to character strings? : Sql dba

1181

---

What is schema in sql example?

1192

---

What does bitemporal mean?

1078

---