Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65260 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / haddy
select ename,salary from (select distinct(salary) from
employee order by salary desc) where rownum<=2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
How many types of tables are there in oracle?
Explain the use of owner option in exp command.
What is the difference between $oracle_base and $oracle_home?
Is there any function in oracle similar like group_concat of mysql?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
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 assign values to variables?
How can we find out the current date and time in oracle?
What are the numeric comparison operations?
How to load data from external tables to regular tables?
List out the types of joins.
How many types of tables supported by oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is dual table oracle?
