Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65619 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 |
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is an oracle cursor variable?
17. Display the order number and average item cost for each order.
How do I uninstall oracle client from windows?
Is the After report trigger fired if the report execution fails ?
How can you use check constraints for self referential integrity?
Why do we use coalesce function in oracle?
Differentiate between translate and replace?
What is object data modeling?
How to recover a dropped table in oracle?
What is analyze command used for?
Write a syntax for update query in oracle?
Oracle General 
