Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 66449 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to connect to a local oracle 10g xe server?
how do u setup a replication site?
How to create an oracle database manually?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
what is IDE,DMV in sql server?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What does sharding mean?
List out the components of logical database structure of oracle database.
Can multiple columns be used in group by in oracle?
Explain overloading. Can functions be overloaded?
Why do we need integrity constraints in a database?
What is meant by an index?
What are advantages of dateset in datastage?
Explain oracle instance.
How to sort output in descending order in oracle?
