Code example for NoArgSQLFunction

	public boolean bindLimitParametersFirst() { 
		return false; 
	public boolean supportsVariableLimit() { 
		return true; 
	public int convertToFirstRowValue(int zeroBasedFirstResult) {
		// Our dialect paginated results aren't zero based. The first row should get the number 1 and so on 
		return zeroBasedFirstResult + 1;
	public String getLimitString(String query, int offset, int limit) {
		// We transform the query to one with an offset and limit if we have an offset and limit to bind 
		if (offset > 1 || limit > 1) return getLimitString(query, true);
		return query;
Contextual code suggestions in your IDE  Get Codota for Java