selectDistinct

fun selectDistinct(vararg results: SelectResult): Select

Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement.

Return

A Select distinct object.

Parameters

results

The array of the SelectResult object for specifying the returned values.


fun selectDistinct(vararg properties: String): Select

Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement.

Return

A Select distinct object.

Parameters

properties

The properties for specifying the returned values.


fun selectDistinct(expression: Expression, vararg expressions: Expression): Select

Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement.

Return

A Select distinct object.

Parameters

expressions

The expressions for specifying the returned values.


fun selectDistinct(expression: Expression, property: String, vararg properties: String): Select

Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement.

Return

A Select distinct object.

Parameters

expression

An expression for specifying the returned value.

properties

Properties for specifying the returned values.


fun selectDistinct(expression: Expression, result: SelectResult, vararg results: SelectResult): Select

Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement.

Return

A Select distinct object.

Parameters

expression

An expression for specifying the returned value.

results

The SelectResult objects for specifying the returned values.