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
How to upsert (update or insert into a table)?
What is tns name?
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.
How to install oracle odbc drivers?
material view and view disadvantages?
What is a oracle database?
What happens to the indexes if a table is recovered?
How do I recompile a procedure in oracle?
Will you be able to store pictures in the database?
Explain oracle’s system global area (sga).
What is a relational database management system?
What is the difference between I and G in Oracle?
What are the system predefined user roles?
How to display employee records who gets more salary than the average salary in the department?
Explain implicit cursor.