Package io.github.fupacat.ast

Class OffsetClause

java.lang.Object

io.github.fupacat.ast.TSqlFragment

io.github.fupacat.ast.OffsetClause

All Implemented Interfaces:

Serializable

public class OffsetClause
extends TSqlFragment

This class represents an offset/fetch filter, that can be used in select statements for paging the result set.

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
ScalarExpression	FetchExpression	Expression for number fo rows to return.
ScalarExpression	OffsetExpression	Expression for number fo rows to skip.
boolean	WithApproximate	True if FETCH APPROXIMATE (or APPROX) keyword was used.

Fields inherited from class io.github.fupacat.ast.TSqlFragment

firstTokenIndex, lastTokenIndex, ScriptTokenStream, Value

Constructor Summary

Constructors

Constructor	Description
OffsetClause()

Method Summary

Modifier and Type	Method	Description
void	accept(TSqlFragmentVisitor visitor)
void	acceptChildren(TSqlFragmentVisitor visitor)

Methods inherited from class io.github.fupacat.ast.TSqlFragment

SetIdentifier, SetUnquotedIdentifier, UpdateTokenInfo, UpdateTokenInfo

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

OffsetExpression

public ScalarExpression OffsetExpression

Expression for number fo rows to skip.

FetchExpression

public ScalarExpression FetchExpression

Expression for number fo rows to return.

WithApproximate

public boolean WithApproximate

True if FETCH APPROXIMATE (or APPROX) keyword was used. Only valid in SQL Server 2025 (170) and above. Note: APPROXIMATE is not valid with OFFSET; only FETCH APPROXIMATE is supported.

Constructor Details

OffsetClause

public OffsetClause()

Method Details

accept

public void accept(TSqlFragmentVisitor visitor)

Specified by:

accept in class TSqlFragment

acceptChildren

public void acceptChildren(TSqlFragmentVisitor visitor)

Overrides:

acceptChildren in class TSqlFragment