src/main/java/com/github/andreptb/fitnesse/JdbcFixture.java
public String queryInWithSql(String database, String sql) {
		JdbcTemplate template = getDatabaseJdbcTemplate(database);
		if (sql != null && !sql.trim().toUpperCase().startsWith(JdbcFixture.SELECT_COMMAND_PREFIX)) {
			return Objects.toString(template.update(sql));
		}
		List<String> results = template.queryForList(sql, String.class);
		if(results == null || results.isEmpty()) {
			return null;
		}
		return results.get(0);
	}
public String queryInWithSql(String database, String sql) {
		JdbcTemplate template = getDatabaseJdbcTemplate(database);
		if (sql != null && !sql.trim().toUpperCase().startsWith(JdbcFixture.SELECT_COMMAND_PREFIX)) {
			return Objects.toString(template.update(sql));
		}
		List<String> results = template.queryForList(sql, String.class);
		if(results == null || results.isEmpty()) {
			return null;
		}
		return results.get(0);
	}
public String queryInWithSql ( String database , String sql ) { JdbcTemplate template = getDatabaseJdbcTemplate ( database ) ; if ( sql != null && ! sql . trim ( ) . toUpperCase ( ) . startsWith ( JdbcFixture . SELECT_COMMAND_PREFIX ) ) { return Objects . toString ( template . update ( sql ) ) ; } List < String > results = template . queryForList ( sql , String . class ) ; if ( results == null || results . isEmpty ( ) ) { return null ; } return results . get ( 0 ) ; }
Used generally when the result is assigned to a variable

<p><code>
| $variable= | query in | <i>database</i> | with sql | <i>sql</i> |
</code></p>
@param database registered database to run the SQL
@param sql to run
Used generally when the result is assigned to a variable