Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120179 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / hasnain hameed
select max(salary)
from emp
where salary < (select max(salary) from emp)
order by salary desc;
i think this is correct answer all of above because it take
less time to execute. retrive the answer quickly.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are stuff and replace function?
How to run sql statements with oracle sql developer?
What is pl sql package?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Is nosql faster than sql?
how to escape special characters in sql statements? : Sql dba
What is a rank in sql?
What is a stored procedure in sql with example?
what are the advantages of using stored procedures? : Sql dba
What is the difference between view and stored procedure?
Explain alias in sql?
Define commit, rollback and savepoint?
What is fmtonly in sql?
Why do we use sql constraints?
What is rowtype?
