how to get the second max val for every group in a table
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suman rana
--venkat u r almost correct, since u have used "" (double
quotes) so column name will be come case sensitive.
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 ? | 0 Yes | 0 No |
Answer / suman rana
select * from emp e where 2 = ( select count(distinct sal)
from emp e1 where e1.deptno = e.deptno and E.SAL <= E1.SAL)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram posam
select * from (select deptno,sal,rank() over(partition by
deptno order by sal desc) k
from emp
group by deptno,sal)
where k=&n;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / indu
select max(sal) from salary where sal NOT IN (select max(sal) from salary)
Is This Answer Correct ? | 9 Yes | 13 No |
what is index?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Explain integrity constraint?
How to create a stored function in oracle?
sql command 2 know current database
What is the difference between 10g OEM and 11g OEM?
How to run the anonymous block again?
Explain the use of rows option in exp command.
How to write text literals in oracle?
how to get last monday of a month?
What are the set operators union, union all, minus & intersect meant to do?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error