Write query to fetch second maximum salary from employee table.
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 are archived logs?
What do you mean by a tablespace?
Differentiate between function and procedure in oracle.
How to pass parameters to procedures?
How would you go about verifying the network name that the local_listener is currently using?
What is oracle host variable?
Difference between the “verify” and “feedback” command?
What privilege is needed for a user to connect to oracle server?
What is key preserved table?
What is the usage of save points in oracle database?
What do database buffers contain?
How to create an oracle testing table?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain self joins in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?