empire-db/src/main/java/org/apache/empire/dbms/h2/DBMSHandlerH2.java [84:107]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	        this.skipRows = skipRows; 
            return this;
	    }
	     
	    @Override
	    public void clearLimit()
	    {
	    	// remove skip and limit
	        this.limitRows = -1;
	        this.skipRows  =  0;
	    }
        
        @Override
        public void getSelect(DBSQLBuilder sql)
        {   // Prepares statement
        	super.getSelect(sql);
            // add limit and offset
            if (limitRows>=0)
            {   sql.append("\r\nLIMIT ");
                sql.append(String.valueOf(limitRows));
                // Offset
                if (skipRows>0) 
                {   sql.append(" OFFSET ");
                    sql.append(String.valueOf(skipRows));
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



empire-db/src/main/java/org/apache/empire/dbms/hsql/DBCommandHSql.java [65:88]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
        this.skipRows = skipRows;
        return this;
    }
     
    @Override
    public void clearLimit()
    {
    	// remove skip and limit
        this.limitRows = -1;
        this.skipRows  =  0;
    }
        
    @Override
    public void getSelect(DBSQLBuilder sql)
    {   // call base class
        super.getSelect(sql);
        // add limit and offset
        if (limitRows>=0)
        {   sql.append("\r\nLIMIT ");
            sql.append(String.valueOf(limitRows));
            // Offset
            if (skipRows>0) 
            {   sql.append(" OFFSET ");
                sql.append(String.valueOf(skipRows));
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -