title: mysql query To get the top two salary from each department
body: <pre>
  **Department table name** 
  **following with fields name**
  
   id , empid ,salary ,departid ,status
  
  </pre>
  
  <p>how to get the top two highest salaries from each department with single query in mysql</p>