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
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain temporal data types in oracle
What is a table index?
Can you assign multiple query result rows to a variable?
Design database draw er diagram for a certain scenario ?
Can you tell me how to add new column in existing views?how?How is possible?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Explain the difference between replace() and translate() functions in oracle?
What is a trigger and what are its types in oracle?
Why use resource manager in Oracle?
What is hot backup and logical backup?
What is a read write transaction in oracle?
How to connect to a remote server?
what are archived logs?
What is the usage of synonyms?