Answer Posted / selvaraj anna university coe

Oracle 10g Using : Find 2nd Highest Salary?

SELECT * FROM emp e WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM emp x
WHERE x.salary >= e.salary);

Answer :

EMP_NO EMP_NAME SALARY
--------- ------------------------- ---------
107 SARABOOT 550000

how do u setup a replication site?

1927

---

What are the numeric comparison operations?

1061

---

What privilege is needed for a user to query tables in another schema?

922

---

Is oracle an operator?

885

---

How to create an initialization parameter file?

987

---

What is data type in oracle?

1043

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2205

---

How oracle handles dead locks?

1021

---

how can we store any pdf file in oracle

2097

---

What do you mean by cdb and pdb in oracle 12c?

1009

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

970

---

Explain integrity constraint?

1112

---

Is there any function in oracle similar like group_concat of mysql?

989

---

What is meant by recursive hints in oracle?

1030

---

How to write a query with a right outer join in oracle?

1115

---