The SKIP LOCKED
Clause
When the SKIP LOCKED
clause is specified, records locked by a different transaction are skipped by the statement and are not updated.
When a ROWS
clause is specified, the “skip locked” check is performed after skipping the requested number of rows specified, and before counting the number of rows to update.