Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153741 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / arijit
donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));
| Is This Answer Correct ? | 52 Yes | 17 No |
Post New Answer View All Answers
What is meant by joins?
What are a query and state the different types of queries and their uses?
What is pragma autonomous transaction in oracle?
What are the different types of failures that occur in Oracle database?
Query to retrieve record for a many to many relationship ?
What is an Oracle index?
What is key preserved table?
How to display employee records who gets more salary than the average salary in the department?
How do I find my oracle client driver version?
How to rename an existing table?
What is meant by an index?
Explain what are the type of synonyms?
What is tns entry?
Explain table?
What is open database communication (odbc) in oracle?
