Interface Select

All Superinterfaces:

QueryExpr, Segment, SelectOperable, Serializable, SetOperable, Statement, Where<Select>, WhereOperable<Select>

All Known Implementing Classes:

Select.Default

public interface Select
extends QueryExpr, Where<Select>, SelectOperable

查询语句

Author:

Maning

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static class	Select.Default	Select默认实现

Method Summary

Modifier and Type	Method	Description
TableRef	from()	from的表
List<Expression>	groupBys()	groupBy的字段
List<Condition>	havings()	having的字段
boolean	isDistinct()	是否去重
List<Join<Select>>	joins()	关联的表
Integer	limit()	限制条数
static Select	of()	创建查询语句
static Select	of(With with)	创建查询语句
Integer	offset()	跳过条数
List<OrderBy>	orderBys()	排序
List<Object>	selections()	查询的列
With	with()	CTE

Methods inherited from interface Segment

pseudoSql, staticable

Methods inherited from interface SelectOperable

as, asSubQuery, clearSelect, crossJoin, crossJoin, crossJoin, distinct, distinct, from, from, from, fullJoin, fullJoin, fullJoin, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, having, having, having, having, having, having, having, having, having, having, having, having, having, join, join, join, join, leftJoin, leftJoin, leftJoin, limit, limit, limit, naturalJoin, naturalJoin, naturalJoin, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, rightJoin, rightJoin, rightJoin, select, select, select, select

Methods inherited from interface SetOperable

except, exceptAll, intersect, intersectAll, setQuery, union, unionAll

Methods inherited from interface Where

wheres

Methods inherited from interface WhereOperable

where, where, where, where, where, where, where, where, where, where, where, where, where

Method Details

of

static Select of()

创建查询语句

Returns:

语句

of

static Select of(With with)

创建查询语句

Parameters:

with - CTE

Returns:

语句

from

TableRef from()

from的表

Returns:

from的表

groupBys

List<Expression> groupBys()

groupBy的字段

Returns:

groupBy的字段

havings

List<Condition> havings()

having的字段

Returns:

having的字段

isDistinct

boolean isDistinct()

是否去重

Returns:

是否去重

joins

List<Join<Select>> joins()

关联的表

Returns:

关联的表

limit

Integer limit()

限制条数

Returns:

限制条数

offset

Integer offset()

跳过条数

Returns:

跳过条数

orderBys

List<OrderBy> orderBys()

排序

Returns:

排序

selections

List<Object> selections()

查询的列

Returns:

查询的列

with

With with()

CTE

Returns:

CTE