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
Post a Comment