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
- 8487 Views
- I also Faced
- E-Mail Answers
Answer Posted / esakkiraja
select a.* from(select dense_rank() over(order by sal)as
new_rank from emp) a where new_rank=2
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you bind variables in oracle?
What privilege is needed for a user to query tables in another schema?
What is Virtual Private Database in Oracle?
What is columnar storage what is the advantage?
What are the uses of synonyms?
What types of joins are used in writing subqueries?
What is the difference between count (*), count (expression), count (distinct expression)?
How to retrieve data from an explicit cursor?
Point the difference between translate and replace?
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.
How to use in conditions in oracle?
What is object data modeling?
How to insert multiple rows with one insert statement in oracle?
What is private procedure oracle?
How to list all indexes in your schema?
