Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151418 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sudheer
Guys Few of you have submitted an optimal query.
select distinct sal from emp A where 3 = (select count(sal)
from emp B where a.sal > b.sal)
However the integer 3 will not give the third highest salary
as expected. Point should be noted that the row starts with
zero.
so the actual result will the fourth highest salary with the
above query.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is a read only transaction in oracle?
What is a server parameter file in oracle?
How can Oracle users be audited?
How to test null values?
What is integrity and what is constraint??Explain with example
What is the difference between PFILE and SPFILE in Oracle?
How to list all tables in your schema?
State any two functions of oracle?
What is a parameter file in oracle?
How many types of cluster table in Oracle?
What is a partition in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How do I learn what codesets are available in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is sequence?
