title: Writing SQL query for getting maximum occurrence of a value in a column
body: <p>I have an <code>emp</code> table with the records below:</p>
  
  <pre><code>INSERT into emp(EmpId,Emp name, Manager)
  Values(1,A,M1)
  values(2,B,M1)
  values(3,C,M2)
  values(4,D,M3)
  </code></pre>
  
  <p>How can I find the <code>Manager</code> having the maximum number of employees under him? In this case, output should be <code>M1</code>. Please help.</p>