Query to get max and second max in oracle in one query ?

Question Posted / neelam

34 Answers
57344 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Query to get max and second max in oracle in one query ?..

Answer / braulio

-- that's it

select * from
(select max(salary) from salary)
where rownum = 2

Is This Answer Correct ?

0 Yes

1 No

Query to get max and second max in oracle in one query ?..

Answer / bhamidipati srinivas

select (select max(gross) from employee_dtls),(select max
(gross) as nextmaximum
from employee_dtls where gross<(select max(gross) from
employee_dtls)) from dual

Is This Answer Correct ?

2 Yes

4 No

Query to get max and second max in oracle in one query ?..

Answer / sdfsfsdf

to install .sh files(.exe files)in linux.copy the file
inusr.
open terminal go to usr and type bash ./follwed by file name
(can use tab key)
here.
to unistall java in linux we can use rm command

Is This Answer Correct ?

1 Yes

4 No

Query to get max and second max in oracle in one query ?..

Answer / naveen

select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))

Is This Answer Correct ?

7 Yes

14 No

Post New Answer