En son tarihe göre;

select ip, tarih from table_name group by tarih count(tarih)>2 order by tarih desc;


İlk tarihe göre;

select ip, tarih from table_name group by tarih count(tarih)>2 order by tarih asc;