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 is normalisation?what are its uses?
Explain about functional dependency and its relation with table design?
How to get execution statistics reports on query statements?
How to change user password in oracle?
What is the difference between view and materialized view in Oracle?
What is ADDM Advisor in Oracle?
How to define an anonymous procedure with variables?
How can we delete duplicate rows in a table?
How does the on-delete-cascade statement work?
What is the difference between I and G in Oracle?
How can you merge two tables in oracle?
Which is better Oracle or MS SQL? Why?
What is the simplest tool to run commands on oracle servers?
what happened to the global index when I truncate the data in one of the partition?
Explain cascading triggers.