Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gyana ranjan behera
sql>select ename,sal from(select ename,sal,rownum rn from
(select ename,sal from emp order by sal desc)
where rn=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to list all tables in your schema?
What are the types of partitions in oracle?
How to delete all rows a table in oracle?
Explain the use of parfile option in exp command.
What do you mean by a tablespace?
What is the relation of a user account and a schema in oracle?
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 are oracle functions?
what is meant by magic query
What is flashback in Oracle?
What is the difference between pre-select and pre-query?
Can we insert data in view oracle?
How to count groups returned with the group by clause in oracle?
How to display employee records who gets more salary than the average salary in the department?
How to delete an existing row from a table in oracle?
