Content deleted Content added
m →Other simple method (a little more efficient than read all rows): lang="postgresql" |
m →Method with filter (it is more sophisticated but necessary for very big dataset): lang="postgresql" |
||
Line 519:
|-
|
<syntaxhighlight lang="
from {table}
order by {unique_key}
FETCH FIRST {rows} ROWS ONLY</syntaxhighlight>
|
<syntaxhighlight lang="
from {table}
where {unique_key} > {last_val}
Line 530:
FETCH FIRST {rows} ROWS ONLY</syntaxhighlight>
|
<syntaxhighlight lang="
from (
select *
| |||