about SQL problem

table_1

[Quoted] [Quoted] 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 Received on Fri Sep 27 2002 - 10:07:05 CEST