Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 8493 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha k
select sal
from (SELECT sal, rownum row_num
FROM emp
order by sal desc)
where row_num = 2;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain a private synonyms?
Give the various exception types.
What is a system tablespace and when it is created?
Explain the use of record option in exp command.
How to create a table index?
How to count duplicated values in a column in oracle?
How to insert a record into a table?
Difference between the “verify” and “feedback” command?
What is pragma autonomous transaction in oracle?
How to create an oracle database?
What is merge statement used for?
How to list all indexes in your schema?
How oracle handles dead locks?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
When do I need to use a semicolon vs a slash in oracle sql?
