Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the second max val for every group in a table
- 6 Answers
- 9607 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / venkat
select * from (
select e.deptno,d.dname,e.sal,dense_rank() over (
partition by e.deptno
order by e.sal desc ) "RANK",
e.ename
from emp_test e,dept_test d
where e.deptno=d.deptno)
where rank=2
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Explain oracle data types with examples?
What is a dead lock in oracle?
What is recovery manager(rman) backup in Oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is a sub query? Describe its types?
How to build data dictionary view an new database?
How to test null values?
What is a trigger and what are its types in oracle?
List the types of joins used in writing subqueries?
What would you do with an in-doubt distributed transaction?
How to use "in" parameter properly?
What is the difference between pre-select and pre-query?
Explain oracle instance.
What are ddl statements in oracle?
if you ctreate table identity
