Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amit bhagat
select min(a.sal) from (select distinct(d.sal) from emp
order by d.sal desc) a where rownum<=5
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Can the query output be sorted by multiple columns in oracle?
What are the various types of snapshots ?
Explain user account with reference to oracle.
How to write numeric literals in oracle?
Where do you use decode and case statements?
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.
Differentiate between pre-select and pre-query?
Please explain oracle data types with examples?
What is an oracle table?
What is the data type of dual table?
What are the attributes of the cursor?
What is the difference between PFILE and SPFILE in Oracle?
What operating systems are supported by oracle database 10g xe?
What privilege is needed for a user to connect to oracle server?
