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 nested table in word?

954

---

What is spool?

1050

---

Why do we use cursors?

984

---

What types of commands can be executed in sql*plus?

1109

---

What is clustered index in sql?

1051

---

Does truncate remove indexes?

1029

---

What is the need of a partition key?

983

---

how is exception handling handled in mysql? : Sql dba

1078

---

What is use of package in pl sql?

1011

---

Are views faster than queries?

988

---

What is normalization? How many normalization forms are there?

1080

---

What is db journal file?

1058

---

Explain the types of joins in sql?

1033

---

what are the nonstandard string types? : Sql dba

1134

---

what is commit? : Sql dba

1069

---