Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65243 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 |
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What are the differences between primary key and unique key?
What is tns name?
How to name query output columns in oracle?
Explain table?
What are the major difference between truncate and delete?
How to drop a stored procedure in oracle?
How to end the current transaction in oracle?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How can you merge two tables in oracle?
What is an Integrity Constrains ?
What is the usage of synonyms?
Oracle General 
