Query to get max and second max in oracle in one query ?
- 34 Answers
- 57465 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarmistha mohanty
select * from (
select SAL,
row_number() over (partition by 1 order by SAL DESC)
as rank
from <table name> ) where rank in (1,2)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?
In which language oracle has been developed?
What are the different editions of oracle?
What are the built-in functions used for sending Parameters to forms ?
Give the various exception types.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Does oracle partitioning improve performance?
Give the various rollback segment states.
Explain implicit cursor.
State all possible different index configurations a table can possibly have?
How does Oracle guarantee data integrity of data changes?
Query to retrieve record for a many to many relationship ?
What is an oracle recycle bin?
How to store only time; not date and time?
Explain oracle’s system global area (sga).
