I have a table with three columns
idclie - client - date
I have two rows where id and client are repeated. I want to delete all rows where and let the one row where date is lesser.
how can I do that?
example of rows:
1 - Alexander Garcia - 10/05/2016
1 - Alexander Garcia - 10/03/2016
1 - Alexander Garcia - 21/01/2016
I use the firebird database, but you can send me an example in SQL that I will try it or make some changes to run it in my DB