Interested to Buy Any Domain ? << Click Here >> for more details...
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 use subqueries in the from clause in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to create a stored function in oracle?
How to view existing locks on the database?
What is oracle analytical function?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is set operator oracle?
Why does oracle 9i treat an empty string as null?
How to turn on or off recycle bin for the instance?
How to install oracle database 10g xe?
Explain parameter file in oracle.
What is the data type of dual table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is dual table oracle?
How many types of cluster table in Oracle?
