Hi I have a single database table where the primary key is (col1 =Date, col2=Time) say This works fine when I wish to delete the oldest record for instance
However I have another column say col3 which holds an increasing sequencial number (i.e. 1, 2,3 etc but not every record has an entry in that column - many records have nothing in that column I am wishing to retrieve the latest two records where that column has a number in it How do I go about that? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/retrieving-records-based-on-a-single-column-contents-tp143982.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
