Search results

I have a table called ORDERS In the table are the following columns: DATE ITEM 01/01/2008 RED 02/02/2007 RED 10/01/2008 BLUE 12/01/2008 RED 05/07/2007 BLUE 03/03/2008 BLUE 04/04/2008 RED From the table, i need a sql query to show the latest TWO dates for EACH item. So the output of...