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 |
How index is implemented in oracle database?
what are actual and formal parameters?
What are the types of synonyms?
How to use subqueries in the from clause in oracle?
What happens if you use a wrong connect identifier?
How to define an anonymous procedure without variables?
What is Trace File ?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What are the common oracle dba tasks?
how to produce numbers from 1 to 10 using dual table
please explain.. DB architecture ...
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.