Re: sql query - easy problem

"Christoph Purrucker" <gugi_at_bigfoot.de> wrote in message news:bk9bfj$mvs$1_at_home.itg.ti.com...
> Hello,
>
> I am doing SQL since a half year, but now I think I
> have a black out: I dont't find a solution for this
> silly problem:
>
> Given the following table:
>
> Product, Type, Date, <... many more cols ...>
> aaa x 2000, ...
> aaa x 2001, ...
> aaa y 2001, ...
> * aaa z 2003, ...
> * bbb z 2002, ...
> bbb x 2001, ...
> ccc x 2000, ...
> ccc x 2002, ...
> ** ccc x 2003, ...
> *** ccc z 2003, ...
>
> I want to have only the row of each product which
> is the most recent (here marked by *).
> When there are Products with the same date I still
> want to have exactly one row (here either ** or ***
> but not both).

select product, MAX(type), MAX(date) from product_table group by product ;

Hope this help Received on Thu Sep 18 2003 - 09:23:07 CDT