Re: latest date

From: Volker Demel <vd_at_demelnet.de>
Date: Thu, 24 May 2001 22:08:13 +0200
Message-ID: <3b0d6abf$0$14099$73bec562@personalnews.de.uu.net>

Hi Vicki,
this is a little tricky, but you have to try something like this:

select i1.*

from     inspection_table i1,
           (Select vehicle#,
                      max(inspection_date) last_date
            from    inspection_table
            group by vehicle#
            ) i2

where i1.vehicle# = i2.vehicle# and i1.inspection_date = i2.last_date;

Hope this helps
Volker

"Vicki" <wellsv_at_mail.modot.state.mo.us> schrieb im Newsbeitrag news:13eb10be.0105241126.333ad05a_at_posting.google.com...
> I need a way to filter out the latest date for records that have more
> than one entry. I have vehicle numbers with entries in a another field
> with the date of inspection. How can I get just the latest date?
Received on Thu May 24 2001 - 15:08:13 CDT