You are right, was a mistake becuase the date is not correct.
Check this code:
Select city,date,temp from mytable;
where temp in;
(select Max(temp) from mytable group by city);
order by city
Juan C.
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E