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
- 9384 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
Will you be able to store pictures in the database?explain.
How to check the server version in oracle?
Which environment variables are absolutely critical in order to run the OUI?
Is oracle a language?
what is the scripts in data base?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What are ddl statements in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to get the Installed Oracle Version Information ?
How to list all user accounts in oracle?
What privilege is needed for a user to query tables in another schema?
How to connect to a local oracle 10g xe server?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to connect the oracle server as sysdba?
Explain the use of rows option in imp command.
