Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9577 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 many data types are supported?
What is meant by an index?
Explain the types of exception?
How to loop through data rows in the implicit cursor?
How to use in conditions in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How many types of auditing in Oracle?
What are the differences between interval year to month and interval day to second?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to convert a string to a date in oracle database?
What is an oracle cursor variable?
What is snapshot is too old? Give and example for better understand.
What is a data dictionary and how can it be created?
How to connect to a local oracle 10g xe server?
What is raw datatype in oracle?
