InterBase 7.x y 2007
ROWS value
[TO upper_value]
[BY step_value]
[PERCENT][WITH TIES]
Ejemplos
SELECT SALESMAN, SALES_DOLLARS, SALES_REGION
FROM SALESPEOPLE
ORDER BY SALES_DOLLARS DESC
ROWS 1 TO 50;
SELECT SALESMAN, SALES_DOLLARS, SALES_REGION
FROM SALESPEOPLE
ORDER BY SALES_DOLLARS DESC
ROWS 50 TO 100 WITH TIES;
Si puede utilizar en Updates y Deletes
Saludos,
Andreano