Answer Posted / abc

Select salary from (select salary from employees order by
salary desc) where rownum <=2;

How do you update a sql procedure?

527

---

What is a memo field?

529

---

What is clustered index sql?

506

---

What's the procedure?

492

---

Is sql scripting language?

526

---

---

What is dense_rank?

540

---

What is snowflake sql?

582

---

What is a sql schema used for?

546

---

What is function and procedure in pl sql?

521

---

What is a pl/sql block?

595

---

List and explain the different types of join clauses supported in ansi-standard sql?

822

---

How to run pl sql program in mysql?

510

---

What is data control language?

532

---

What are properties of the transaction?

560

---

What is recursive stored procedure?

605

---