Answer Posted / dev anand s

select salary from (
select salary, dense_rank() over(order by salary desc) rank from emp) where rank=2;

What are the advantages of pl sql?

600

---

What is acid property in a database?

580

---

Is primary key an index?

531

---

What is the function that is used to transfer a pl/sql table log to a database table?

553

---

What is an implicit commit?

552

---

---

What is a join?

621

---

What are string functions in sql?

674

---

How does a self join work?

516

---

What are the types of join in sql?

518

---

What is a table in a database?

575

---

What do you mean by “trigger” in sql?

617

---

what is clause? : Sql dba

582

---

What is a nested table in word?

529

---

What is the use of pl/sql table?

553

---

What does stand for in sql?

522

---