Answer / sudipta santra

select max(sal),group_nm from
( select sal,dense_rank over (order by sal desc) rank,group_nm
from emp )
where rank=&n
group by group_nm;


Note: here &n is the bind variable which holds value from
the user, based on the requirement either 2nd max or 3rd max
or 5th max.

Answer / nathan

SELECT *
FROM (SELECT deptno, sal,
DENSE_RANK () OVER (PARTITION BY deptno ORDER
BY sal DESC)

ranks
FROM emp)
WHERE ranks = 2;

Explain the use of ignore option in imp command.

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers  

---

Explain the features of oracle?

0 Answers  

---

In which language oracle has been developed?

0 Answers  

---

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

1 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

How to use "startup" command to start default instance?

0 Answers  

---

State the various uses of dbcc command?

0 Answers  

---

Explain the use of control file?

0 Answers  

---

What are the differences between interval year to month and interval day to second?

0 Answers  

---