Module litebridge.orm

Package org.litebridgedb.orm.api.select

Interface LimitClauseTerminal<DTO>

Type Parameters:

DTO - the data transfer object (DTO) type that represents the result of the query

All Superinterfaces:

SelectTerminal<DTO>

All Known Subinterfaces:

FromClauseTerminal<DTO,JC,JCC,JCCT,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>, GroupByClauseTerminal<DTO,HCC,HCCT,OBC,OBCC>, HavingClauseTerminal<DTO,OBC,OBCC>, HavingConditionClauseTerminal<DTO,HCC,SELF,OBC,OBCC>, JoinClauseTerminal<DTO,JC,JCC,JCCT,WCC,WCCT,GBCT,HCC,HCCT,OBC,OBCC>, OrderByClauseChain<DTO,OBC,OBCC>, OrderByClauseTerminal<DTO>, SqlJoinClauseTerminal, WhereClauseTerminal<DTO,GBCT,HCC,HCCT,OBC,OBCC>, WhereConditionClauseTerminal<DTO,WCC,SELF,GBCT,HCC,HCCT,OBC,OBCC>

All Known Implementing Classes:

org.litebridgedb.orm.api.select.impl.AbstractFromClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractGroupByClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractHavingClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractJoinClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractJoinConditionClauseTerminal, org.litebridgedb.orm.api.select.impl.AbstractWhereClauseTerminal, DtoFromClauseTerminal, DtoGroupByClauseTerminal, DtoHavingConditionClauseTerminal, DtoJoinConditionClauseTerminal, DtoOrderByClauseChain, DtoWhereConditionClauseTerminal, org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl, org.litebridgedb.orm.api.select.impl.OrderByClauseTerminalImpl, SqlFromClauseTerminal, SqlGroupByClauseTerminal, SqlHavingConditionClauseTerminal, SqlJoinConditionClauseTerminal, SqlOrderByClauseChain, SqlWhereConditionClauseTerminal

public interface LimitClauseTerminal<DTO>
extends SelectTerminal<DTO>

Terminal clause for applying a LIMIT clause in a SQL query.

This interface provides functionality to set an offset for skipping a specified number of rows in the result set, which is commonly used for implementing pagination.

Method Summary

Modifier and Type	Method	Description
SelectTerminal<DTO>	offset(int offset)	Sets an offset to skip a specified number of rows in the result set.

Methods inherited from interface org.litebridgedb.orm.api.select.SelectTerminal

first, firstOrNull, firstOrThrow, firstOrThrow, list, one, oneOrNull, oneOrThrow, oneOrThrow, stream, toSql

Method Details

offset

SelectTerminal<DTO> offset(int offset)

Sets an offset to skip a specified number of rows in the result set. This is typically used in combination with a limit clause for implementing pagination in queries.

Parameters:

offset - the number of rows to skip in the result set, must be a non-negative integer

Returns:

an instance of SelectTerminal<DTO> to continue building or executing the query