Re: Help With SQL Statement

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 25 Feb 2009 13:05:38 -0600
Message-ID: <jCgpl.23528$ZP4.15525_at_nlpi067.nbdc.sbc.com>



Andy wrote:
> Hi Gang
>
> I have a table that has the following.
>
> Part Revision
> AA1234 1
> AA1234 2
> AA1234 3
> BB8877 1
> BB8877 2
> CC3211 1
> CC3211 2
> CC3211 3
> CC3211 4
>
> I want to create a query that will only pull out latest or (max)
> revisions. So I want a query that would only return.
>
> AA1234 3
> BB8877 2
> CC3211 4
>
> Does anyone know how to do this?
>
> Thanks
> Andy

yes we know how to do this... the only hint I would give since you haven't even shown us what you tried is one of the key words in your request... search for MAX and you will find it. If you ask someone else to do your homework for you, how will you ever learn? Received on Wed Feb 25 2009 - 13:05:38 CST

Original text of this message