Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7269 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answer Posted / ritesh
select max(salary) from emptable where salary < (select max(salary) from emptable);
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
Explain implicit cursor.
Explain what are synonyms used for?
Can we create trigger on materialized view in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What happens if you set the sga too low in oracle?
Who developed oracle & when?
What is a proxy class?
What is Reduced List of Values?
What do you mean by merge in oracle?
Where is the export dump file located?
what is the difference between data migration and production migration.
What are the execution control statements?
Where do you use decode and case statements?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
