title: count highest occurance category-wise in sql select statement
body: <p>I have a table from which i want to COUNT highest no of occurrence category-wise and output that specific entry only.</p>
  
  <p>I tried this query but no luck
      $sql="  SELECT category,article,COUNT(*)
          FROM articles_likes
          WHERE category = '{$category}'
          GROUP BY article
          DESC";</p>
  
  <p>for eg:</p>
  
  <p>table - </p>
  
  <pre><code>article category
  1         A
  1         B
  1         B
  2         A
  2         A
  2         B
  3         A
  4         B
  </code></pre>
  
  <p>Expected output - </p>
  
  <p>If I select A then it should be 2</p>
  
  <p>If I select B then it should be 1</p>