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
What are oracle functions?
Explain user account with reference to oracle.
How do I limit the number of rows returned by an oracle query after ordering?
What are the uses of Database Trigger ?
What is the max number of columns in an oracle table?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to load data from external tables to regular tables?
How to write a left outer join with the where clause in oracle?
What are the varoius components of physical database structure of oracle database?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to connect to the server with user account: sys?
What is clustered table in Oracle?
What is rowid and rownum in oracle?
Explain coalesce function?
What are the execution control statements in oracle?