how to return colum by number row from mysql Follow
Answered
Hi experts.
I wanna return only columns of row two.
but i cant understand , how to indicate the int of row two.
I am working with the version inteli j idea community.
statement = sql.createStatement();
resultset = statement.executeQuery(consulta);
while (resultset.next()) {
String Bd_TestCase = resultset.getString("TestCase");
}
Please sign in to leave a comment.
Hello,
You can get columns from the second row by adding WHERE clause to your SQL query e.g.:
SELECT * FROM tb_az_tc_creartest WHERE Id = 2;
Does it help?