how to return colum by number row from mysql


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 ( {
String Bd_TestCase = resultset.getString("TestCase");



1 comment
Comment actions Permalink


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?


Please sign in to leave a comment.