Write query to fetch second maximum salary from employee table.
Answer Posted / abhishekjaiswal
select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is max rowid in oracle?
How to use subqueries with the exists operator in oracle?
Can you create a synonym without having a table?
How can we find out the current date and time in oracle?
what is the difference between data migration and production migration.
what are the advantages of running a database in archive log mode?
Name the various constraints used in oracle?
Why is oracle database so popular?
How to get maxsal , minsal, ename department wise in single query
Will you be able to store pictures in the database?explain.
What are the different types of synonyms?
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.
What are the different types of failures that occur in Oracle database?
What is merge in oracle?
What is tns name?