find out the second highest salary?
Answer Posted / premsagar12
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Can you have more than one content canvas view attached with a window ?
How to use "in out" parameter properly?
Explain the use of full option in exp command.
What is Data Dictionary Cache in Oracle?
What is private procedure oracle?
How to create additional tablespaces for an new database?
Is insert autocommit in oracle?
Is primary key indexed by default in oracle?
Difference between open_form and call_form in oracle.
How to drop a stored function?
Can multiple cursors being opened at the same time?
What is the usage of analyze command in oracle?
How to specify default values in insert statement using oracle?
Can sub procedure/function be called recursively?
What happens to indexes if you drop a table?