Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118169 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 is the difference between $message and $$message? : Sql dba
What is Materialized View? In What Scenario we Use Materialized View?
Define overloaded procedure?
What is a unique key?
What does trigger mean in slang?
What is a left join?
Can we insert data in view?
How much does sqlite cost?
What is update query?
tell us something about heap tables. : Sql dba
What is a recursive stored procedure?
What is trigger in pl sql?
What is the difference between jpql and sql?
Does truncate need commit?
what are all different types of collation sensitivity? : Sql dba
