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 to login to the server without an instance?

1167

---

How to run create database statement?

1038

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2143

---

How many types of cluster table in Oracle?

1034

---

What suggestions do you have to reduce the network traffic?

967

---

What is recycle bin in Oracle?

1154

---

What happens to the current transaction if the session is killed?

991

---

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

1068

---

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

1023

---

Explain the use of rows option in imp command.

1088

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1070

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2190

---

Please explain compound trigger in oracle?

1065

---

What is a server parameter file in oracle?

1061

---

What is SQL access advisor in Oracle?

1196

---