I do not use sqlserver
and for this reason I have set myself the task to consult how to create a limit
, I have realized that to bring a certain number of records from a query I use SELECT TOP cantidad
, execute the query and it effectively brought me the number of records...
The problem I have is how to tell the query to bring me from one initial value to another, that is, from 1000 to 2000.
JUDGMENT
SELECT TOP ".$rowperpage."
maepro.PRCODI,
maepro.PrNomb
FROM
maepro
WHERE
maepro.PrSta = 'S' ".$searchQuery." ORDER BY maepro.PrNomb ASC";
I would appreciate the interest.