Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 87684 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / shiv prakash
select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;
| Is This Answer Correct ? | 20 Yes | 18 No |
Post New Answer View All Answers
How to initialize variables with default values?
Explain the use of inctype option in exp command.
Where do we use decode and case statements?
What is the oracle implicit cursor?
Can you create a synonym without having a table?
Explain the use of rows option in imp command.
Explain the use of tables option in exp command.
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What happens to the current transaction if the session is ended?
What is java oracle used for?
What is an oracle user account?
How to add another datafile to a tablespace?
What is a cursor in oracle?
What happens to indexes if you drop a table?
How index is implemented in oracle database?
