Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65563 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 |
Explain the use of full option in exp command.
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Explain what are the different type of segments?
What is the function of Redo Log ?
What are advantages fo Stored Procedures?
What is the sid in oracle?
What is ordinary table in oracle?
what is the difference between UNION AND UNIONALL
What is the difference between translate and replace in oracle?
What is an oracle database table?
Explain the difference between replace() and translate() functions in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
Oracle General 
