Package net.sf.jsqlparser.statement.select

Interface Summary

Interface	Description
FromItem	An item in a "SELECT [...]
FromItemVisitor
IntoTableVisitor
OrderByVisitor
PivotVisitor
SelectBody
SelectItem	Anything between "SELECT" and "FROM" (that is, any column or expression etc to be retrieved with the query)
SelectItemVisitor
SelectVisitor

Class Summary

Class	Description
AllColumns	All the columns (as in "SELECT * FROM ...")
AllTableColumns
Distinct	A DISTINCT [ON (expression, ...)] clause
ExceptOp
ExpressionListItem
Fetch	A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
First	A FIRST clause in the form [FIRST row_count] the alternative form [LIMIT row_count] is also supported.
FromItemVisitorAdapter
FunctionItem
IntersectOp
IntoTableVisitorAdapter
Join	A join clause
LateralSubSelect	A lateral subselect followed by an alias.
Limit	A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
MinusOp
Offset	An offset clause in the form OFFSET offset or in the form OFFSET offset (ROW | ROWS)
OrderByElement	An element (column reference) in an "ORDER BY" clause.
OrderByVisitorAdapter
Pivot
PivotVisitorAdapter
PivotXml
PlainSelect	The core of a "SELECT" statement (no UNION, no ORDER BY)
Select
SelectExpressionItem	An expression as in "SELECT expr1 AS EXPR"
SelectItemVisitorAdapter
SelectVisitorAdapter
SetOperation	Single Set-Operation (name).
SetOperationList	A database set operation.
Skip	A skip clause in the form [SKIP row_count] Initial implementation was done for informix special syntax: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0156.htm
SubJoin	A table created by "(tab1 join tab2)".
SubSelect	A subselect followed by an optional alias.
TableFunction
Top	A top clause in the form [TOP (row_count) or TOP row_count]
UnionOp
ValuesList	This is a container for a values item within a select statement.
Wait	A timeout applied to SELECT to specify how long to wait for the row on the lock to be released.
WithItem	One of the parts of a "WITH" clause of a "SELECT" statement

Enum Summary

Enum	Description
First.Keyword
OrderByElement.NullOrdering
SetOperationList.SetOperationType	list of set operations.