Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118591 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 are tables and fields?
how to run 'mysql' commands from a batch file? : Sql dba
What is rtm in testing?
What is natural join in sql?
Does sql profiler affect performance?
how to use regular expression in pattern match conditions? : Sql dba
What language is oracle sql developer?
What is normalization? How many normalization forms are there?
what is rollback? : Sql dba
Write a sql query to get the third highest salary of an employee from employee_table?
How are sql commands classified?
What does cursor do in sql?
what is the difference difference between procedure and packages
what are the advantages of sql ? : Sql dba
Is and as keyword in pl sql?
