find out the third highest salary?
Answer Posted / nitin berwal
select top 1 salary from(select top 3 salary from emp order
by desc) a
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create lov dynamically at runtime & attach to text field?
How to drop an existing view in oracle?
How to grant create session privilege to a user in oracle?
What is a nvl function?
State the difference between a primary key and foreign key?
Can a parameter be passed to a cursor?
How to use an explicit cursor without open statements?
What are the built-in functions used for sending Parameters to forms ?
Where are the settings stored for each instance in oracle?
Point the difference between translate and replace?
Explain database link?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What are the different pseudo commands? Explain in general?
How do I spool to a csv formatted file using sqlplus?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??