Re: about SQL problem
Date: 27 Sep 2002 14:00:55 -0700
Message-ID: <4306a83.0209271300.3f1094cb_at_posting.google.com>
" Q O " <_at_@> wrote in message news:<3d9418b6_at_shknews01>...
> table_1
> code num units price date
> 1 1 1 2002-07-02
> 1 7 1.5 2002-07-08
> 2 2 5 2002-07-03
> 2 1 2.3 2002-07-04
> 2 4 2 2002-07-28
> 3 3 1.5 2002-07-01
> 3 2 1.235 2002-07-10
>
> how can i construct a SQL statment to retrieve all red colo rows.
> the date should be max(date) in each code
It migth be helpfull if you provided a litle more hints. What du you acctualy want? Received on Fri Sep 27 2002 - 23:00:55 CEST