title: count row numbers by using single sql statement
body: <p>I have a query like <code>SELECT * table from etc order by something LIMIT 10</code> but in the same time I also want to know the TOTAL row results in the table. Do I need to do another sql?</p>