Re: latest date

From: Mark J. Bobak <mark.NOSPAM_at_bobak.net>
Date: Fri, 25 May 2001 01:20:58 GMT
Message-ID: <20010524.212059.1470503465.5550@bobak.net>

Unless I misunderstand, you have something like: table inspections

---

inspect_id number
vehicle_id number
inspection_date date

Then, it should be as simple as:
select vehicle_id, max(inspection_date) from inspections group by vehicle_id;

That will give you the latest date for each vehicle.

Is that what you want?

-Mark
In article <13eb10be.0105241126.333ad05a_at_posting.google.com>, "Vicki" <wellsv_at_mail.modot.state.mo.us> wrote:

> 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 - 20:20:58 CDT