Interested to Buy Any Domain ? << Click Here >> for more details...
How to Select second Maximum salary in a Table ?
- 13 Answers
- 15226 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh
select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where is the export dump file located?
What do you understand by a database object?
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.
Explain coalesce function?
What is the difference between alert log file and tarce file ?
What is meant by a deadlock situation?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What are the different pseudo commands? Explain in general?
How to manage transaction isolation level?
How do we represent comments in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
How to list all indexes in your schema?
How to create lov dynamically at runtime & attach to text field?
How to download oracle database 10g xe?
