Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sql query - easy problem
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, ...is the most recent (here marked by *).
* 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
I know that this table is not normalized but I get it in this form by a flat file... :-(
Thanks.
cp Received on Wed Sep 17 2003 - 05:02:24 CDT