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
- 9727 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 do you increase the OS limitation for open files (LINUX and/or Solaris)?
Why cursor variables are easier to use than cursors?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain constraining triggers.
master table and child table performances and comparisons in Oracle ?
What is ADDM Advisor in Oracle?
What is an oracle user role?
What are the original export and import utilities?
What is a schema in oracle?
what is a Nested Loop join?
State the various uses of dbcc command?
how may join possible between (requisition with purchase order)
How to delete a column in an existing table?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to use null as conditions in oracle?
