Diwakar,
If you haven't seen Mark's
note yet, please update your last name do more than an initial.
Regardless of whether this is a homework assignment, the key is to start building the query in little pieces.
Do you know how to write a SQL query to find out the highest salary? The second highest salary? The employee with a specific salary? Post some of these and then we can work with you to merge them into the query you need. Or you may find that the query writes itself at that point. Or if you get stuck on one of these, we can point you in the right direction.
