Answer Posted / amit bhagat
select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get a create statement for an existing table?
What is transport network substrate (tns) in oracle?
What is an oracle tablespace?
Explain about your project and its relation to the current job position you are applying to?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to drop an existing view in oracle?
What are the execution control statements in oracle?
How to Truncate Table in Oracle
How to use values from other tables in update statements using oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How do I uninstall oracle client from windows?
How to save query output to a local file?
Why oracle is used?
How to export data with a field delimiter?
How to do paging with oracle?