select_set_limit


Description:

[ Version ( since = "4.2" ) ]
public void select_set_limit (SqlBuilderId limit_count_expr_id, SqlBuilderId limit_offset_expr_id)

If limit_count_expr_id is not 0, defines the maximum number of rows in the DataModel resulting from the execution of the built statement.

In this case, the offset from which the rows must be collected can be defined by the limit_offset_expr_id expression if not 0 (note that this feature may not be supported by all the database providers).

If limit_count_expr_id is 0, then removes any LIMIT which may have been imposed by a previous call to this method.

Parameters:

this

a SqlBuilder object

limit_count_expr_id

the ID of the LIMIT expression, or 0

limit_offset_expr_id

the ID of the OFFSET expression, or 0