find out the third highest salary?
- 92 Answers
- 129006 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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How many file formats are supported to export data?
What are the limitations of check constraint?
What is parameterized cursor in oracle?
What is a procedure in oracle?
How to run create database statement?
How to convert raw data type into text in oracle? Explain
What is redo log?
Explain about functional dependency and its relation with table design?
How do I manually create a database in oracle?
What is SQL access advisor in Oracle?
Explain the importance of .pll extension in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is a trigger and what are its types in oracle?
What is a trigger and what are its types?
