how to return colum by number row from mysql

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");
}

 

 

1 comment
Comment actions Permalink

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?

0

Please sign in to leave a comment.