find out the third highest salary?
- 92 Answers
- 128793 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / brijesh
hi,
this query gives you the Nth highest salary, the trick is to
write (N-1) in the given place;
select salary from table as table1
where (n-1) =
(select count(salary) from table
where table1.salary<salary);
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Can multiple cursors being opened at the same time?
What is the difference between formal parameters and actual parameters?
What are the different pseudo commands? Explain in general?
What is the difference between a user and a schema in oracle?
what happened to the global index when I truncate the data in one of the partition?
What is oracle server autotrace in oracle?
Why is oracle used?
How to omit columns with default values in insert statement in oracle?
What are the common oracle dba tasks?
How to export your connection information to a file?
How to use "while" statements in oracle?
What is private procedure oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
State all possible different index configurations a table can possibly have?
What is a synonym? What are its various types?
