Query to get max and second max in oracle in one query ?
- 34 Answers
- 57426 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can the query output be sorted by multiple columns in oracle?
What happens to the indexes if a table is recovered?
How to get execution statistics reports on query statements?
How to create id with auto_increment on oracle?
Please explain oracle left join with an example?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to write a query with an inner join in oracle?
What is oracle analytical function?
What is an oracle database?
How do I uninstall oracle 11g?
What is merge in oracle?
How to view the data files in the current database?
What are triggers in oracle?
Explain what are synonyms used for?
What is the usage of save points in oracle database?
