Select Class
Exposes API to deal with conditions and other constraints used in query.
Item Index
Methods
and
-
column
Used to specify AND condition between where clause.
Parameters:
-
column
StringName of column on which condition need to be specified.
Returns:
Clause Interface Implementation.
ascendingOrderBy
-
columns
Used to specify ORDER BY ASC keyword to sort the result-set in ascending order.
Parameters:
-
columns
StringName of columns which need to be sorted.
Returns:
Select Interface Implementation.
column
-
column
Used to provide name of column only for which data will be fetched.
Parameters:
-
column
StringName of column.
Returns:
Select Interface Implementation.
columns
-
column
Used to provide name of columns only for which data will be fetched.
Parameters:
-
column
ArrayName of columns.
Returns:
Select Interface Implementation.
delimiter
-
val
Used to provide delimiter
Parameters:
-
val
StringValue of delimiter
Returns:
Select Interface Implementation
descendingOrderBy
-
columns
Used to specify ORDER BY DESC keyword to sort the result-set in descending order.
Parameters:
-
columns
StringName of columns which need to be sorted.
Returns:
Select Interface Implementation.
distinct
()
Object
Used to specify DISTINCT condition.
Returns:
Select Interface Implementation.
execute
()
Process the request specified by application.
executeAsync
()
Process the request asynchronous specified by application.
groupBy
-
columns
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
Parameters:
-
columns
ArrayName of columns.
Returns:
Select Interface Implementation.
having
-
column
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
Parameters:
-
column
StringName of column on which condition need to be applied.
Returns:
Clause Interface Implementation.
havingClause
-
havingClause
Used to provide manually created Where clause, instead of using API's.
Parameters:
-
havingClause
StringWhere clause.
Returns:
Select Interface Implementation.
limit
-
limit
Used to specify the range of data need to fetch from table.
Parameters:
-
limit
StringLIMIT of data.
Returns:
Select Interface Implementation.
or
-
column
Used to specify OR condition between where clause.
Parameters:
-
column
StringName of column on which condition need to be specified.
Returns:
Clause Interface Implementation.
orderBy
-
columns
Used to specify ORDER BY keyword to sort the result-set.
Parameters:
-
columns
StringName of columns which need to be sorted.
Returns:
Select Interface Implementation.