Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7496 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 happens to the data files if a tablespace is dropped?
Is the After report trigger fired if the report execution fails ?
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.
How to count duplicated values in a column in oracle?
What is an oracle database table?
What is an Oracle Instance?
What is define in oracle?
What are temporal data types in oracle?
How to write text literals in oracle?
What are privileges and grants?
How to create a stored function in oracle?
What is the dynamic sql in oracle?
How to drop a stored function?
How to run queries on external tables?
What is a system tablespace?
