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 what are clusters?

0 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

does Oracle has only one table space?

1 Answers   Oracle,

---

Can a View based on another View ?

3 Answers  

---

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

---

How can we force the database to use the user specified rollback segment?

0 Answers  

---

How to rename an existing table?

0 Answers  

---

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

2 Answers   Oracle, SAH,

---

what is main def between plsql/table and array?

1 Answers   Oracle,

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

What is Hash Cluster ?

2 Answers  

---