Module litebridge.orm

Package org.litebridgedb.orm.api.select

Interface OrderByClauseTerminal<DTO>

Type Parameters:

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

All Superinterfaces:

LimitClauseTerminal<DTO>, 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>, 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.OrderByClauseTerminalImpl, SqlFromClauseTerminal, SqlGroupByClauseTerminal, SqlHavingConditionClauseTerminal, SqlJoinConditionClauseTerminal, SqlOrderByClauseChain, SqlWhereConditionClauseTerminal

public interface OrderByClauseTerminal<DTO>
extends LimitClauseTerminal<DTO>

Terminal clause of an ORDER BY operation.

This interface enables the application of a LIMIT clause to restrict the number of rows in the query result.

Method Summary

Modifier and Type	Method	Description
LimitClauseTerminal<DTO>	limit(int limit)	Limits the number of rows returned in a query result.

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

offset

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

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

Method Details

limit

LimitClauseTerminal<DTO> limit(int limit)

Limits the number of rows returned in a query result.

Parameters:

limit - the maximum number of rows to be returned. Must be a positive integer.

Returns:

an instance of LimitClauseTerminal to allow for further query customization or execution.