Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / amitkumar
Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How will you differentiate between varchar & varchar2?
How to convert characters to dates in oracle?
How to run the anonymous block again?
What are the built-in functions used for sending Parameters to forms ?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Hi Can any one tell me what are the API's used in requisition import.
How to define a sub function?
Respected sir, Please send me technical questions related to oracle apps..
How to rename an existing table?
Explain the use of grant option in imp command.
Explain rename?
What is an oracle wallet?
How to resolve the ORA-39133 error in Oracle?
What is a cursor and what are the steps need to be taken?
how do u setup a replication site?