case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT ");
case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT ");
if (query.isDistinct()) { sql.append("DISTINCT ");
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }
if (query.isDistinct()) { sql.append("DISTINCT ");
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }