Billing Statement

I want to get the number of rows returned (Select count * from [table] where employeeNo = ?). I just want the integer which will be returned, using java programming. I know how to do resultset etc if it is a regular sql statement but how should I capture just the count result?

Thanks

Try "count(*)" instead of "count *". Then just getInt(1) from your ResultSet.

Posted select statement |