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
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