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 to use "if" statements on multiple conditions?
What is a user account in oracle?
How do I find the database name in oracle?
How is it different from a normal table?
How does the on-delete-cascade statement work?
Explain the importance of .pll extension in oracle?
How view is different from a table?
What is meant by joins? List out the types of joins.
What are the components of logical database structure in oracle database?
How to list all indexes in your schema?
How to retrieve values from data fields in record variables?
What is a view and how is it different from a table?
How can you use check constraints for self referential integrity?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?