Answer Posted / aswini
select min(sal) from (select sal from emp order by sal desc) where rownum<=100
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate pl/sql and sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
How to load data with sql*loader?
How can I delete duplicate rows?
what is the difference between nested subquery and correlated subquery?
What is oracle and pl sql?
Does oracle use sql?
what is the difference between primary key and unique key? : Sql dba
What is data abstraction in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What are stuff and replace function?
Why is a primary key important?
How do I run a script in sql developer?
What is procedure explain with example?
what are different types of keys in sql?