Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151105 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
What happens if the update subquery returns multiple rows?
What is the oracle implicit cursor?
What is index-organized table in Oracle?
What is Data Dictionary Cache in Oracle?
How to drop a stored procedure in oracle?
Explain the use of rows option in exp command.
What are the different types of failures that occur in Oracle database?
What is java oracle used for?
interview questions with answer for cts
What are the extensions used by oracle reports?
What is system global area (sga) in oracle?
Why do we need oracle client?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to upsert (update or insert into a table)?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
