Answer Posted / yaswanth

select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;

What problem one might face while writing log information to a data-base table in pl/sql?

1158

---

Why are aggregate functions called so?

946

---

What is the usage of when clause in trigger?

1051

---

What are dml commands?

1020

---

What are the built in functions of sql?

1027

---

What is consistency?

1117

---

What are the different types of triggers?

1131

---

What is data abstraction in sql?

1024

---

Which are the different character-manipulation functions in sql?

1061

---

What is compound trigger?

1034

---

What is pl sql record in oracle?

1026

---

What is recursive join in sql?

1004

---

What is sap sql anywhere?

1069

---

What is difference between ms sql and mysql?

959

---

What are the different sql languages?

1034

---