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
- 8635 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
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is a subquery in oracle?
How to save query output to a local file?
What do you know about normalization? Explain in detail?
What is ceil and floor in oracle?
How are extents allocated to a segment?
What is the oracle implicit cursor?
What are advantages of dateset in datastage?
What is not equal to in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is primary key indexed by default in oracle?
What is Reduced List of Values?
How does oracle handle read consistency?
What is a private synonym?
What is a package ? What are the advantages of package ?
