find out the second highest salary?
Answer Posted / kiran
select max(empsal) from emp where rownum<=2
| Is This Answer Correct ? | 24 Yes | 188 No |
Post New Answer View All Answers
How are extents allocated to a segment?
various types of hints and their usage
What privilege is needed for a user to create indexes in oracle?
How do I know if oracle client is installed on windows?
When do you get a .pll extension in oracle? Explain its importance
When do we use group by clause in a sql query?
What do you mean by merge in oracle?
What is enter substitution variable in oracle?
Whether any commands are used for months calculation? If so, what are they?
What is Undo Management Advisor in Oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the components of logical database structure in oracle database?
Explain coalesce function?
What is a trigger oracle?
How do I limit the number of rows returned by an oracle query after ordering?