Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / apsar
select sal from (select sal,count(sal) over order by salary desc c)temp where temp.c=&n;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
How many types of database triggers exist?
How to pass a parameter to a cursor in oracle?
Explain cascading triggers.
List out the types of joins.
What is the difference between post-database commit and post-form commit?
What is the difference between 10g OEM and 11g OEM?
State some uses of redo log files?
What is logical backup in oracle?
State the various uses of dbcc command?
How many types of auditing in Oracle?
please explain.. DB architecture ...
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is a nvl function?
What are the differences between date and timestamp in oracle?