Hi to everyone.
First of all, sorry for my bad english..
Second, I have a problem with a query.
I have a table with some field like field1, field2, field3, field4 and some duplicated rows apart
for the value contained in the field4 that in my case in a type date.
I would like to select all the duplicated rows by the same value of "field2" , and then delete the one with the latest date.
Till now i just manage to write a query that select all the cuple of duplicated rows depending on the field2 , but then i don't how to erase (among the cuple) the rows with the latest date(field4).
SELECT * FROM table WHERE field2 IN
GROUP BY field2
HAVING count(*)=2) order by field2