Search results

Thanks Raskew this worked great, just a few questions, what does DISTINCT and LEFT JOIN actually do? ps. thanks everyone else too

Hi, This only gives me output for one item, i need the two latest dates for EACH item. PLEASE HELP..

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...