Answer Posted / manoj

SELECT min(salary)
FROM (
SELECT e.salary , ROWNUM
FROM emp e
ORDER BY salary DESC
AND ROWCOUNT <=3
)
ROWNUM =3;

What is before trigger?

948

---

Can I join the same table twice?

996

---

What are different types of statements supported by sql?

1099

---

how can you create an empty table from an existing table? : Sql dba

1080

---

What is forward declaration in pl sql?

1008

---

What is a .db file?

928

---

What is a variable in sql?

953

---

What is the use of primary key?

953

---

What is java sql drivermanager?

1023

---

What is embedded sql with example?

989

---

What are the features of pl sql?

1015

---

What is the purpose of primary key?

968

---

what happens if null values are involved in expressions? : Sql dba

1001

---

What are different methods to trace the pl/sql code?

1050

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

---