find out the third highest salary?
- 92 Answers
- 128238 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 are the roles of dba?
How to pass parameters to procedures?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
what is IDE,DMV in sql server?
What are the restrictions in a oracle read only transaction?
How to write a query with a right outer join in oracle?
When do you get a .pll extension in oracle? Explain its importance
What is the usage of save points in oracle database?
Can we write dml statement in function in oracle?
List out the components of logical database structure of oracle database.
What is a package in oracle?
How index is implemented in oracle database?
Can you drop an index associated with a unique or primary key constraint?
What is transaction control statement and how many types of transaction control statement in Oracle?
Can group functions be used in the order by clause in oracle?
