Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116140 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
how to include comments in sql statements? : Sql dba
How to select all records from the table?
What are the differences between implicit and explicit cursors?
Does inner join return duplicate rows?
Can variables be used in sql statements?
What steps server process has to take to execute an update statement?
What is varchar used for?
How do I remove sql plus from windows 10?
How do sql databases work?
explain advantages of innodb over myisam. : Sql dba
Are sql database names case sensitive?
What is the difference between jpql and sql?
What is the difference between left outer join and left join?
What are the indexing methods?
How do I run sql profiler?
