Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64317 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / braulio
-- that's it
select * from
(select max(salary) from salary)
where rownum = 2
| Is This Answer Correct ? | 0 Yes | 1 No |
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 |
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 |
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 |
How many types of tables are there in oracle?
if you update view? where we store the data?
How to get the Installed Oracle Version Information ?
what is the bitmap index?
What is oracle open database communication (odbc)?
What is the difference between implicit index and explicit index?
How to add a new column to an existing table in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the difference between postgresql and oracle?
what is foreign key?
How can I see all tables in oracle?
Does facebook use oracle?
Oracle General 
