Re: pulling out a subset of records

Hi My exposure to derby so far has only involved creating a database, adding records or deleting a record. I have not extracted a subset which which to further process Bob M -- View this message in context:

Re: pulling out a subset of records

Well then it's as simple as Select count (*) from table where colA=valueA and colB=valueB... and colN=valueN On a side note, you should probably have a look at an sql tutorial so that you can familiarize with standard syntax, operation, indexing, and aggregation function. Regards Il

pulling out a subset of records

Hi I have derby database consisting of several thousand records Each record has 35 fields I wish to :- (1) extract a subset of these records where 8 specific fields are identical to a pre-defined set of values for those 8 fields (2) printout the number of records in the subset any help with

Re: pulling out a subset of records

Hi Bob Either I am missing something or that looks a lot like a standard sql select count ... can you please add some details? Il 20/Ott/2015 06:34, "Bob M" ha scritto: > Hi > > I have derby database consisting of several thousand records > Each record has 35 fields > >

Re: pulling out a subset of records

So, if I understand correctly : -You have a have a table with 35 columns - you want to count the number of records that have colA=valueA, colB=valueB... colN=valueN Correct? Il 20/Ott/2015 07:06, "Bob M" ha scritto: > Hi > > My exposure to derby so far has only

Re: pulling out a subset of records

yes- correct Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144946.html Sent from the Apache Derby Users mailing list archive at Nabble.com.