Answer Posted / s. syam sundar

1.SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL = 2 CONNECT BY
PRIOR SAL >SAL GROUP BY LEVEL
2.SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM <3
MINUS
SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM = 1
3.SELECT MAX(SAL) FROM EMP WHERE SAL <> (SELECT MAX(SAL)
FROM EMP)

regards
syam sundaar

what is bdb (berkeleydb)? : Sql dba

1038

---

What are procedures used for?

991

---

Name three sql operations that perform a sort.

1019

---

define join and explain different type of joins? : Sql dba

955

---

How do I count rows in sql query?

999

---

How to read/write files from pl/sql?

1045

---

Is a view faster than a stored procedure?

976

---

How many sql statements are used? Define them.

1045

---

What is oracle and pl sql?

1124

---

Can you have more than one trigger on a table?

1004

---

How do I tune a sql query?

981

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1004

---

Explain what is a view?

1066

---

What is a left inner join?

1022

---

explain normalization concept? : Sql dba

1053

---