Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151442 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / deepal saini
this is the best way to find out thethird highest salary from emp table
select max(sal) from emp where sal<(select max(sal) from emp where sal <(select max(sal)from emp));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is faster join or subquery in oracle?
how to join query for one source type is oracle another source type is sql server ?
How to add another datafile to a tablespace?
How to update values on multiple rows in oracle?
What is blob data type in oracle?
What is control file used for?
Explain the use of log option in exp command.
How to create an oracle database manually?
How to use values from other tables in update statements using oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Is the After report trigger fired if the report execution fails ?
What privilege is needed for a user to query tables in another schema?
How to run queries on external tables?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain what are the type of synonyms?
