db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald McLean <dmclea...@gmail.com>
Subject Re: Question About Selecting Only Some Records in a Join Query
Date Sat, 20 Jun 2009 22:05:13 GMT
It seems to me that you could probably use a subquery to get the last date
of service. It's a bit more complicated with separate fields for the date
parts. You might even have to use nested subqueries. Get the largest service
year, use that as a key and get the largest month for records in that
service year and then get the largetst service day in that service
year/month and then use that to select records from the table.

View raw message