Module litebridge.orm

Package org.litebridgedb.orm.api.sql

Class SqlGroupByClauseTerminal

java.lang.Object

org.litebridgedb.orm.api.select.impl.DelegatingSelector<Row,SqlSelectSpec>

org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl<Row,SqlSelectSpec>

org.litebridgedb.orm.api.select.impl.OrderByClauseTerminalImpl<Row,SqlSelectSpec>

org.litebridgedb.orm.api.select.impl.AbstractGroupByClauseTerminal<Row,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>

org.litebridgedb.orm.api.sql.SqlGroupByClauseTerminal

All Implemented Interfaces:

GroupByClauseTerminal<Row,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>, HavingClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain>, LimitClauseTerminal<Row>, OrderByClauseTerminal<Row>, SelectTerminal<Row>

public class SqlGroupByClauseTerminal
extends org.litebridgedb.orm.api.select.impl.AbstractGroupByClauseTerminal<Row,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>

Field Summary

Fields inherited from class org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl

selectSpec

Fields inherited from class org.litebridgedb.orm.api.select.impl.DelegatingSelector

delegate

Constructor Summary

Constructors

Constructor	Description
SqlGroupByClauseTerminal(SqlSelector delegate)

Method Summary

Modifier and Type	Method	Description
SqlHavingConditionClause	having(ExpressionSpec expression)
SqlOrderByClause	orderBy(String... columns)	Adds an ORDER BY clause to the query, specifying the expressions to sort the results by.
SqlOrderByClause	orderBy(ExpressionSpec... columns)	Adds an ORDER BY clause to the query, specifying the fields and expressions to sort the results by.

Methods inherited from class org.litebridgedb.orm.api.select.impl.OrderByClauseTerminalImpl

limit

Methods inherited from class org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl

offset, selectSpec

Methods inherited from class org.litebridgedb.orm.api.select.impl.DelegatingSelector

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

Methods inherited from class java.lang.Object

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

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

offset

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

limit

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

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

Constructor Details

SqlGroupByClauseTerminal

public SqlGroupByClauseTerminal(SqlSelector delegate)

Method Details

having

public SqlHavingConditionClause having(ExpressionSpec expression)

orderBy

public SqlOrderByClause orderBy(String... columns)

Description copied from interface: HavingClauseTerminal

Adds an ORDER BY clause to the query, specifying the expressions to sort the results by.

Parameters:

columns - the expressions that determine the order of the results. Each column must be valid for the associated table or view in the query. The order in which the expressions are specified determines the priority of ordering.

Returns:

an instance of the type representing the ORDER BY clause, allowing further specification of ordering or transitioning to the next query stage.

orderBy

public SqlOrderByClause orderBy(ExpressionSpec... columns)

Description copied from interface: HavingClauseTerminal

Adds an ORDER BY clause to the query, specifying the fields and expressions to sort the results by.

Parameters:

columns - the expressions that determine the order of the results.

Returns:

an instance of the type representing the ORDER BY clause, allowing further specification of ordering or transitioning to the next query stage.