Answer Posted / srijith pillai

This will give you third highest salary

select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;

What is set serveroutput on in pl sql?

567

---

What is compiled query?

522

---

What is rowtype?

568

---

Differentiate between pl/sql and sql?

619

---

What are pl sql procedures?

518

---

---

what is msql? : Sql dba

568

---

Can we commit in trigger?

549

---

What is sql architecture?

561

---

What is a temp table?

570

---

What is a sql schema used for?

546

---

What are the disadvantages of file system?

617

---

What are the key differences between SQL and PL SQL?

628

---

How to return multiple rows from the stored procedure?

524

---

How many indexes can be created on a table in sql?

497

---

how many triggers are allowed in mysql table? : Sql dba

559

---