Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102933 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sanjib b
select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you update sql?
What is union and union all keyword in sql?
How to get each name only once from an employee table?
what are the authentication modes in sql server? : Sql dba
What is auto increment?
What is the difference between syntax error and runtime error?
What is oracle sql developer?
What is Materialized View? In What Scenario we Use Materialized View?
Give the order of sql select?
Explain the structure of pl/sql in brief.
How to read xml file in oracle pl sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
What are the types of keys?
write an sql query to find names of employee start with 'a'? : Sql dba
How to create your own reports in sql developer?
