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
- 9324 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
Can select statements be used on views in oracle?
What is the difference between online and offline backups?
What is a proxy class?
How can I combine multiple rows into a comma-delimited list in oracle?
What is MTTR advisor in Oracle?
How to change user password in oracle?
How to export data to a csv file?
What is BBED in Oracle?
What are the different windows events activated at runtime ?
Why cursor variables are easier to use than cursors?
Explain oracle left join with an example?
Query to retrieve record for a many to many relationship ?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the sid in oracle?
What is tns name?
