Write a query to get 2nd maximum salary in an employee table ?
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 delete all records from table in sql?
Where not exists in sql?
Does sql*plus have a pl/sql engine?
What do you mean by rowid?
Can we call procedure in select statement?
what does the t-sql command ident_current does? : Transact sql
When to use inner join and left join?
how to do backup entire database? : Transact sql
how to rename an existing table in mysql? : Sql dba
How many rows can sqlite handle?
What is the most common sql injection tool?
How do you update a sql procedure?
How do I add a database to sql?
What are the main features of cursor?
how mysql optimizes distinct? : Sql dba