db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Counting a subset of records
Date Wed, 05 Dec 2018 02:01:45 GMT
I have a table with a particular column named ID

The records in the table have an integer in the field and there may be
several records with the same integer value

I am using the following code where Search_ID has just been
calculated...........

ps = conn.prepareStatement("SELECT COUNT(*) from table_name where ID =
Search_ID");

The program falters on this line and I am unclear why ?

Bob M



--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Mime
View raw message