Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102913 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sushant hole
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
What is difference between hql and sql?
What is the usage of the distinct keyword?
How many subqueries can be nested in a statement?
How can you know that statistics should be updated?
How can you view the errors encountered in a trigger?
Which data dictionary views have the information on the triggers that are available in the database?
Why sql query is slow?
Explain the select statement in sql?
What is the difference between a query and a report?
what is single byte over head in oracle..?
What are functions in sql?
What is not null in sql?
what is acid property in database? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is difference between pls_integer and integer?
