how to select second mauximum value in a given table under salary column
- 6 Answers
- 7806 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / shri
select min(sal) from (select * from emp order by sal desc) where rownum<3
IN Informatica also use the query in source qualifier's
"sql override". which will reduce d no. of t/r in d mapping
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to run the anonymous block again?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the relation of a user account and a schema in oracle?
Explain cascading triggers.
How to bring a tablespace online?
What is the data pump import utility?
How to fetch the row which has the max value for a column?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is an oracle and why it is used?
How to create a new table in oracle?
What are the set operators union, union all, minus & intersect meant to do?
Explain overloading. Can functions be overloaded?
Explain self joins in oracle?
Where do we use decode and case statements?
How to connect to a remote server?
