Sintaxa acestor opţiuni:
[ OFFSET offset { ROW | ROWS } ] [ FETCH { FIRST | NEXT } [ { rowcount | percent PERCENT } ] { ROW | ROWS } { ONLY | WITH TIES } ]
Explicaţii:
select * from stud order by nume,prenume OFFSET 100 ROWS; select * from stud order by nume,prenume OFFSET 100 ROWS FETCH NEXT 100 ROWS ONLY; select * from stud order by nume,prenume OFFSET 100 ROWS FETCH NEXT 10 PERCENT ROWS ONLY; select * from stud order by nume,prenume OFFSET 100 ROWS FETCH NEXT 100 ROWS WITH TIES;
Referinţe: