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

Interface SQLSelectWhereStep

All Superinterfaces:
SQLBuildStep, SQLConditionStep<SQLSelectWhereStep>, SQLSelectBuildStep
public interface SQLSelectWhereStep extends SQLSelectBuildStep, SQLConditionStep<SQLSelectWhereStep>
A SELECT with a completed WHERE clause and optional grouping or ordering.
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

    • groupBy

      SQLSelectGroupByStep groupBy(SQLExpression first, SQLExpression... others)
      Adds the ordered expressions used to group the SELECT result.
      Parameters:
      first - the first expression in the GROUP BY clause
      others - additional grouping expressions appended in SQL order
      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