Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65574 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
Please explain oracle data types with examples?
What is an oracle user role?
Explain coalesce function?
Is there a combination of "like" and "in" in sql?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Give the various exception types.
How to create an oracle testing table?
What are ddl statements in oracle?
How to work with data objects interactively?
What are the various constraints used in oracle?
Explain drop constraint oracle?
What is different types of joins?
what is meant by magic query
What are the most common interview questions on ETL Testing for experience?
What is oracle datasource?
