Package com.exasol.sql.dql.select

Class OrderByClause

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dql.select.OrderByClause

All Implemented Interfaces:

SelectFragment, Fragment

public class OrderByClause
extends AbstractFragment
implements SelectFragment

This class represents the ORDER BY clause of an SQL statement.

Field Summary

Fields inherited from class com.exasol.sql.AbstractFragment

root

Constructor Summary

Constructors

Constructor	Description
OrderByClause(SqlStatement rootStatement, ColumnReference... columnReferences)	Create a new instance of a OrderByClause.

Method Summary

Modifier and Type	Method	Description
void	accept(SelectVisitor visitor)	Accept a visitor (e.g.
OrderByClause	asc()	Add ASC option to the OrderByClause
OrderByClause	desc()	Add DESC option to the OrderByClause
List<ColumnReference>	getColumnReferences()	Get list of column references.
Boolean	getDesc()	Get descending.
Boolean	getNullsFirst()	Get nulls first.
OrderByClause	nullsFirst()	Add NULLS FIRST option to the OrderByClause
OrderByClause	nullsLast()	Add NULLS LAST option to the OrderByClause

Methods inherited from class com.exasol.sql.AbstractFragment

getRoot

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.sql.Fragment

getRoot

Constructor Detail

OrderByClause

public OrderByClause(SqlStatement rootStatement,
                     ColumnReference... columnReferences)

Create a new instance of a OrderByClause.

Parameters:

rootStatement - SQL statement this ORDER BY clause belongs to

columnReferences - column references for the ORDER BY clause

Method Detail

accept

public void accept(SelectVisitor visitor)

Description copied from interface: SelectFragment

Accept a visitor (e.g. a renderer or validator)

Specified by:

accept in interface SelectFragment

Parameters:

visitor - visitor to accept

getColumnReferences

public List<ColumnReference> getColumnReferences()

Get list of column references.

Returns:

column name

desc

public OrderByClause desc()

Add DESC option to the OrderByClause

Returns:

instance ofOrderByClause for fluent programming

asc

public OrderByClause asc()

Add ASC option to the OrderByClause

Returns:

instance ofOrderByClause for fluent programming

getDesc

public Boolean getDesc()

Get descending.

Returns:

true if descending

nullsFirst

public OrderByClause nullsFirst()

Add NULLS FIRST option to the OrderByClause

Returns:

instance ofOrderByClause for fluent programming

nullsLast

public OrderByClause nullsLast()

Add NULLS LAST option to the OrderByClause

Returns:

instance ofOrderByClause for fluent programming

getNullsFirst

public Boolean getNullsFirst()

Get nulls first.

Returns:

true if nulls first