mySQL: Can I make count() honor limit clause? -


I am trying to get the count of records matching a few criteria within a subset of the total records. I tried (and assumed that this would work)

  select number (*) from records where position = 'ADP' limit 0,10  

And I assumed it would tell me how many records of ADP were recorded in that set of 10 records. It is not - it gives returns in this case 30, which is the total number of ADP records in the table.

How do I count the records of matching my criteria, including boundaries?

  from select count (*) (select from table where position = 'ADP' Limit 0, 10)  

Comments