Hi I have a large table with some duplicate rows that I want to delete. Essentially I have two columns, one containing a date and one containing a number. The number column can contain duplicates. For any row containing duplicate values I want to remove all rows bar the oldest.
i.e. if the data is 1 1/1/2011 2 1/1/2011 2 2/1/2011 3 1/1/2011 3 2/1/2011 3 3/1/2011 5 7/1/2011 I want to be left with 1 1/1/2011 2 1/1/2011 3 1/1/2011 5 7/1/2011 -- Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
