Query to get max and second max in oracle in one query ?
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
Explain the use of inctype option in exp command.
what are the advantages of running a database in archive log mode?
How to apply filtering criteria at group level in oracle?
What is define in oracle?
Explain the difference between replace() and translate() functions in oracle?
What are the different types of record groups in oracle? Explain each of them
How to get the Installed Oracle Version Information ?
Explain the use of ignore option in imp command.
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Can we use bind variables in oracle stored procedure?
What do you know about normalization? Explain in detail?
What privilege is needed for a user to query tables in another schema?
How to create tables for odbc connection testing?
How to start a new transaction in oracle?
How can we find out the current date and time in oracle?