find out the second highest salary?
Answer Posted / anitha
select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between truncate & delete command?
What are the built-in functions used for sending Parameters to forms ?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a sub query? What are its various types?
How to start a new transaction in oracle?
Difference between open_form and call_form in oracle.
How to create an oracle testing table?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is the difference between post-database commit and post-form commit?
How to export data with a field delimiter?
Why use resource manager in Oracle?
What is instant client oracle?
How to load data from external tables to regular tables?
How many types of synonyms in Oracle?