Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 103207 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / ahmad
Select Max(VacationHours) "MVacHrs"
from HumanResourcesEmployee
where VacationHours not in (Select Max(VacationHours)
from HumanResourcesEmployee)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the use of pl/sql table?
What is cte?
What does dml mean?
What is trigger and types?
Explain the difference between 'between' & 'and' operators in sql
What does count (*) do in sql?
What is a field in a database?
What is use of package in pl sql?
what is a database? : Sql dba
What does stand for in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Is sql dba a good career? : SQL DBA
How to write pl sql program in mysql command prompt?
What is scope of pl sql developer in future?
How show all rows in sql?
