@Override public SqlLimitResponse limit(SqlLimitRequest request) { StringBuilder sb = new StringBuilder(512); sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } sb.append(request.getDbSql()); int maxRows = request.getMaxRows(); if (maxRows > 0) { sb.append(" ").append(NEW_LINE).append("FETCH FIRST ").append(maxRows).append(" ROWS ONLY"); } String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); } }
public SqlLimitResponse limit(SqlLimitRequest request) { StringBuilder sb = new StringBuilder(512); sb.append("select "); if (request.isDistinct()){ sb.append("distinct "); } sb.append(request.getDbSql()); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (maxRows > 0) { maxRows = maxRows + 1; } sb.append(" ").append(NEW_LINE).append(LIMIT).append(" "); if (maxRows > 0) { sb.append(maxRows); } if (firstRow > 0) { sb.append(" ").append(OFFSET).append(" "); sb.append(firstRow); } String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
public SqlLimitResponse limit(SqlLimitRequest request) { String dbSql = request.getDbSql(); StringBuilder sb = new StringBuilder(50 + dbSql.length()); sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } sb.append(dbSql); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (maxRows > 0 || firstRow > 0) { sb.append(" ").append(LIMIT).append(" ").append(maxRows); if (firstRow > 0) { sb.append(" ").append(OFFSET).append(" "); sb.append(firstRow); } } String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow + 1; if (useFirstRowsHint && request.getMaxRows() > 0) { sb.append("/*+ FIRST_ROWS(").append(request.getMaxRows() + 1).append(") */ ");
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow + 1; if (useFirstRowsHint && request.getMaxRows() > 0) { sb.append("/*+ FIRST_ROWS(").append(request.getMaxRows() + 1).append(") */ ");
public SqlLimitResponse limit(SqlLimitRequest request) { String dbSql = request.getDbSql(); StringBuilder sb = new StringBuilder(50 + dbSql.length()); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (firstRow < 1) { // just use top n sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } sb.append("top ").append(maxRows).append(" "); sb.append(dbSql); return new SqlLimitResponse(sb.toString(), false); } sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } sb.append(dbSql); if (firstRow > 0) { sb.append(" ").append("offset"); sb.append(" ").append(firstRow).append(" rows"); } if (maxRows > 0) { sb.append(" fetch next ").append(maxRows).append(" rows only"); } String sql = sb.toString(); return new SqlLimitResponse(sql, false); }
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow; if (useFirstRowsHint && request.getMaxRows() > 0) { sb.append("/*+ FIRST_ROWS(").append(request.getMaxRows()).append(") */ ");
public SqlLimitResponse limit(SqlLimitRequest request) { StringBuilder sb = new StringBuilder(512); sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } sb.append(request.getDbSql()); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (maxRows > 0) { maxRows = maxRows + 1; } sb.append(" ").append(NEW_LINE).append(LIMIT).append(" "); if (maxRows > 0) { sb.append(maxRows); } if (firstRow > 0) { sb.append(" ").append(OFFSET).append(" "); sb.append(firstRow); } String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow;
public SqlLimitResponse limit(SqlLimitRequest request) { String dbSql = request.getDbSql(); StringBuilder sb = new StringBuilder(60 + dbSql.length()); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); /* * SELECT TOP xx START AT xx ... FROM ... */ sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } if (maxRows > 0) { sb.append("top ").append(maxRows).append(" "); } if (firstRow > 0) { sb.append("start at ").append(firstRow + 1).append(" "); } sb.append(dbSql); String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow + 1;
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow + 1;
public SqlLimitResponse limit(SqlLimitRequest request) { StringBuilder sb = new StringBuilder(500); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (maxRows > 0) { // fetch 1 more than we return so that // we know if more rows are available maxRows = maxRows + 1; } /* * SELECT TOP xx START AT xx ... FROM ... */ sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } if (maxRows > 0) { sb.append("top ").append(maxRows).append(" "); } if (firstRow > 0) { sb.append("start at ").append(firstRow + 1).append(" "); } sb.append(request.getDbSql()); String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
public SqlLimitResponse limit(SqlLimitRequest request) { StringBuilder sb = new StringBuilder(500); int firstRow = request.getFirstRow(); int maxRows = request.getMaxRows(); if (maxRows > 0) { // fetch 1 more than we return so that // we know if more rows are available maxRows = maxRows + 1; } /* * SELECT TOP xx START AT xx ... FROM ... */ sb.append("select "); if (request.isDistinct()) { sb.append("distinct "); } if (maxRows > 0) { sb.append("top ").append(maxRows).append(" "); } if (firstRow > 0) { sb.append("start at ").append(firstRow + 1).append(" "); } sb.append(request.getDbSql()); String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery()); return new SqlLimitResponse(sql, false); }
int lastRow = request.getMaxRows(); if (lastRow > 0) {
int lastRow = request.getMaxRows(); if (lastRow > 0) {
int lastRow = request.getMaxRows(); if (lastRow > 0) { lastRow = lastRow + firstRow;