Help With SQL Statement

#1

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

#2

Andy escribió:

Quote:

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

#3

Andy wrote:

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Help With SQL Statement

comp.databases.oracle.misc comp.databases.oracle.misc

Help With SQL Statement - 02-23-2009 , 09:31 AM

Re: Help With SQL Statement - 02-23-2009 , 10:23 AM

Re: Help With SQL Statement - 02-25-2009 , 01:05 PM