Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102938 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / pramod majhi
select max(salary) from employees where salary<(select
max(salary) from employees);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are stuff and replace function?
What is the difference between sql and t sql?
What is data manipulation language?
Can a view be mutating? If yes, then how?
Is it possible to read/write files to-and-from PL/SQL?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Where is pl sql used?
What are sql objects?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is a loop in sql?
How does cross join work in sql?
Is left join faster than join?
How do I upgrade sql?
What is a temp table?
What is memory optimized?
