Write query to fetch second maximum salary from employee table.
- 4 Answers
- 6573 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
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
How to define a specific record type?
How to run the anonymous block again?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the difference between $oracle_base and $oracle_home?
What is the difference between count (*), count (expression), count (distinct expression)?
What are triggers in oracle?
What is a read write transaction in oracle?
What is oracle rowcount?
Is rowid unique in oracle?
How to define a record variable to store a table row?
definition of cluster and non-clustered index?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to loop through a cursor variable?
What are joins, explain all types of joins?
How to run queries on external tables?
