title: Get the total count of rows and rows limited by number with same query
body: <p>Suppose in table A i have many rows with column values a,b,c,d.</p>
  
  <p>Out of these, I want 10 rows with column value 'c' while also counting the total number of rows with column value 'c'.</p>
  
  <p>i tried:</p>
  
  <pre><code>select count(*),* from A where column like 'c'; (without limit)
  
  select count(*),* from A where column like 'c' limit 10;
  </code></pre>
  
  <p>Is this even possible? or would i have to fire two queries.</p>