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
What are the differences between blob and clob in oracle?
What happens if variable names collide with table/column names?
various types of hints and their usage
What is oracle in java?
How to drop a stored function?
How to get a list of all user accounts in the database?
What is raw datatype?
What are the four Oracle system processes that must always be up and running for the database to be useable?
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?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How do I call oracle stored procedures that take no parameters?
How to create an oracle testing table?
What is hot backup and logical backup?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
