title: How to find second highest salary in mysql
body: <p>How to find second highest salary in mysql.
  All record find in second highest salary.</p>
  
  <pre><code>Table : Employee
  ID    salary      emp_name
  1     400         A
  2     800         B
  3     300         C
  4     400         D
  4     400         C
  
  *** Mysql Query: ***
  SELECT * FROM employee ORDER by salary DESC LIMIT 1,2
  </code></pre>
  
  <p>This return two record.I do not know how many record in second highest salary.</p>