Help With SQL Statement

From: Andy <andy.mcvicker_at_siemens.com>
Date: Mon, 23 Feb 2009 07:31:13 -0800 (PST)
Message-ID: <abfb8819-7a0d-4e8d-95e5-ac987d3db60f_at_e18g2000vbe.googlegroups.com>

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 Received on Mon Feb 23 2009 - 09:31:13 CST

This message: [ Message body ]
Next message: Álvaro G. Vicario: "Re: Help With SQL Statement"
Previous message: Álvaro G. Vicario: "Re: Abort slow queries"
Next in thread: Álvaro G. Vicario: "Re: Help With SQL Statement"
Reply: Álvaro G. Vicario: "Re: Help With SQL Statement"
Reply: Michael Austin: "Re: Help With SQL Statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message