Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147721 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / husenaiah.b
select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal
| Is This Answer Correct ? | 22 Yes | 38 No |
Post New Answer View All Answers
How to retrieve data from an cursor to a record?
How does oracle handle read consistency?
What is java oracle used for?
What are the different oracle database objects?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to retrieve data from an explicit cursor?
How to manage transaction isolation level?
what is Single Byte Overhead...?
What are the restrictions on external table columns?
Describe the types of sub query?
How to save query output to a local file?
What is Reduced List of Values?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
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.
What is an Oracle index?
