>1.- Select city,date,Max(temp) from yourtable order by city group by city,date
>Juan C.

---

This select would return date from last physical record for each city not date corresponded to Max(temp).