Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118167 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
Is sql better than excel?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
how can we optimize or increase the speed of a mysql select query? : Sql dba
How show all rows in sql?
What is a table in a database?
How do you update a sql procedure?
Can you have more than one trigger on a table?
How to write a query to show the details of a student from students table whose
Explain table and field in sql?
What is a schema sql?
What is use of trigger?
Can we delete column in sql?
Why cross join is used?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is embedded sql what are its advantages?
