Package org.eclipse.net4j.db.dml.fluent

Interface SQLSelectGroupByStep

All Superinterfaces:
SQLBuildStep, SQLSelectBuildStep
public interface SQLSelectGroupByStep extends SQLSelectBuildStep
A SELECT with GROUP BY expressions and optional HAVING or ordering clauses.
Since:
4.15
Author:
Eike Stepper
No Implement
This interface is not intended to be implemented by clients.
No Extend
This interface is not intended to be extended by clients.

  • Method Details

    • having

      SQLComparisonStep<SQLSelectHavingStep> having(SQLExpression left)
      Supplies a complete reusable HAVING condition or begins a comparison. Complete conditions may be composed with explicit grouping; simple connector chains use SQL operator precedence.
      Parameters:
      left - the left expression of a comparison
      Returns:
      the next valid fluent stage
      Since:
      4.15

    • having

      SQLSelectHavingStep having(SQLCondition condition)
      Supplies a complete reusable HAVING condition or begins a comparison. Complete conditions may be composed with explicit grouping; simple connector chains use SQL operator precedence.
      Parameters:
      condition - the complete condition to add
      Returns:
      the next valid fluent stage
      Since:
      4.15

    • orderBy

      SQLSelectOrderByStep orderBy(SQLOrderItem first, SQLOrderItem... others)
      Starts an ORDER BY clause with the supplied items in order.
      Parameters:
      first - the first ordering item in the ORDER BY clause
      others - additional ordering items appended in SQL order
      Returns:
      the next valid fluent stage
      Since:
      4.15

    • orderByDesc

      SQLSelectOrderByStep orderByDesc(SQLExpression expression)
      Starts an ORDER BY clause with one descending expression.
      Parameters:
      expression - the expression used by this clause
      Returns:
      the next valid fluent stage
      Since:
      4.15