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 are the advantages of oracle 12c?
How to create additional tablespaces for an new database?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are the differences between date and timestamp in oracle?
Explain the use of rows option in imp command.
How to use "in out" parameter properly?
How do you bind variables in oracle?
Give the various exception types.
ABOUT IDENTITY?
Is java required for oracle client?
What are the different pseudo commands? Explain in general?
Explain the use of grant option in exp command.
How to create a table index?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can we use bind variables in oracle stored procedure?