Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120149 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 handle bulk data?
what are rollup and cube in t-sql? : Transact sql
explain primary keys and auto increment fields in mysql : sql dba
define data blocks ? : Sql dba
Why stored procedures are faster than query?
How do you write a complex sql query?
What are its different types of dbms?
What are the steps for performance tuning.
Can you have a foreign key without a primary key?
how to get a list of indexes of an existing table? : Sql dba
What is dense_rank in sql?
How do temporal tables work?
What are the advantages of sql? Explain
How do I audit the sql sent to the server?
Define implicit and explicit cursors.
