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

Interface SQLSelectOrderByStep

All Superinterfaces:
SQLBuildStep, SQLSelectBuildStep
public interface SQLSelectOrderByStep extends SQLSelectBuildStep
A complete SELECT ordering clause that can accept further ordering items. A SQLExpression is also an ordering item and defaults to ascending order; use SQL.asc(SQLExpression) or SQL.desc(SQLExpression) for an explicit direction. orderByDesc() and thenByDesc() are convenience alternatives. Items retain their supplied order.
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

    • thenBy

      SQLSelectOrderByStep thenBy(SQLOrderItem item)
      Appends an ordering item after the current ORDER BY items. A direct expression is ascending by default.
      Parameters:
      item - the next ordering item
      Returns:
      the next valid fluent stage
      Since:
      4.15

    • thenByDesc

      SQLSelectOrderByStep thenByDesc(SQLExpression expression)
      Appends a descending expression after the current ORDER BY items.
      Parameters:
      expression - the expression used by this clause
      Returns:
      the next valid fluent stage
      Since:
      4.15