Re: Help With SQL Statement
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Mon, 23 Feb 2009 17:23:00 +0100
Message-ID: <gnuih4$7kj$1_at_news.motzarella.org>
Andy escribió:
> 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?
Date: Mon, 23 Feb 2009 17:23:00 +0100
Message-ID: <gnuih4$7kj$1_at_news.motzarella.org>
Andy escribió:
> 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?
SELECT Part, MAX(Revision) AS MaxRevision
FROM Whatever
GROUP BY Part
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://bits.demogracia.com -- Mi web de humor al baño María: http://www.demogracia.com --Received on Mon Feb 23 2009 - 10:23:00 CST