title: How to get "LAST RECORD WITH COUNT (MySql)"?
body: <p>I have a table named "articles".
  article(id,article,category,title).
  My table structure is as follows :</p>
  
  <p>TABLE :</p>
  
  <pre><code>+----+-------------------------+---------------+
  | id | article| category       | title         |
  +----+-------------------------+---------------+
  | 1  | a1     | a              | ta1           |
  | 2  | a2     | a              | ta2           |
  | 3  | b1     | b              | tb1           |
  | 4  | b2     | b              | tb2           |
  | 5  | b3     | b              | tb3           |
  | 6  | c1     | c              | tc1           |
  | 7  | c2     | c              | tc2           |
  | 8  | c3     | c              | tc3           |
  +----+-------------------------+---------------+
  </code></pre>
  
  <p>One "category" can have mutiple "article" related to it, that is number of article can belong to same category. I have to find COMPLETE record of the last entered article in each category.</p>
  
  <pre><code>SELECT id,article,category,title FROM articles
  WHERE article IN(SELECT MAX(article) FROM articles GROUP BY category)
  </code></pre>
  
  <p>This query gives :</p>
  
  <pre><code>+----+-------------------------+-------+
  | id | article| category       | title |
  +----+-------------------------+-------+
  | 2  | a2     | a              | ta2   |
  | 5  | b3     | b              | tb3   |
  | 8  | c3     | c              | tc3   |
  +----+-------------------------+--------
  </code></pre>
  
  <p>NOW along with this OUTPUT, i have to find COUNT of articles in each category.
  My required OUtput is:</p>
  
  <pre><code>+----+-------------------------+-------+-------+
  | id | article| category       | title | Count |
  +----+-------------------------+-------+-------+
  | 2  | a2     | a              | ta2   | 2     |
  | 5  | b3     | b              | tb3   | 3     |
  | 8  | c3     | c              | tc3   | 3     |
  +----+-------------------------+----------------+
  </code></pre>
  
  <p>Help me with the query ????????/</p>