MySql的:
SELECT * FROM tablename limit position, counter
SELECT * FROM tablename limit position, counter
PostgreSQL的:
SELECT * FROM tablename LIMIT counter OFFSET position;
SELECT * FROM tablename LIMIT counter OFFSET position;
Oracle的:
SELECT * FROM tablename WHERE ROWNUM<position_end;
minus
SELECT * FROM tablename WHERE ROWNUM<position_start;
SELECT * FROM tablename WHERE ROWNUM<position_end;
minus
SELECT * FROM tablename WHERE ROWNUM<position_start;
InterBase/Firebird的:
SELECT * FROM tablename ROWS position_start to position_end
SELECT * FROM tablename ROWS position_start to position_end