Query to get max and second max in oracle in one query ?
Answers were Sorted based on User's Feedback
Answer / satish
SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM EMP) WHERE RANK=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satish
SELECT SAL SECOND_MAX_SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM EMP) WHERE RANK=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Select Sal From Emp A
WHERE 1=(Select Count(Sal) From Emp B
WHERE B.Sal>A.sal)
GROUP By Sal Desc
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shareef
select ename,empno,sal,r from(select ename,empno,sal,dense_rank() over(order by sal desc) r from emp) where r=3; ----by using dense_rank()
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajit
select max(sal),1 no
from emp
union
select sal,rn from (select sal,rownum rn from emp)
where rn = 2
order by 1 desc;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / asdasd
SELECT min(gross) FROM(SELECT distinct(gross) FROM
srbs_staff_pay_dtls ORDER
BY gross DESC) WHERE ROWNUM<=4;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / at_avrat_braveheart
select amcık from göt_tarlası
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / abcd
for page break or form feed we use following
  /f (char)12
for nbsp;
(char)10  
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sarmistha mohanty
select * from (
select SAL,
row_number() over (partition by 1 order by SAL DESC)
as rank
from <table name> ) where rank in (1,2)
Is This Answer Correct ? | 1 Yes | 2 No |
Please explan Why static query is more faster than dynamic query ?
pls explain connect by prior with example and its real time use
What is the difference between truncate & delete command?
what is trigger?
What is the usage of synonyms?
How to use "startup" command to start default instance?
How to open a cursor variable?
How to connect to a local oracle 10g xe server?
What does `(+)` do in a where clause?
How to define a procedure inside another procedure?
What is a trigger oracle?
Can a formula column referred to columns in higher group ?