By doing that,

Code:
SELECT MAX(DATE) FROM Table1
It only display one record, but they are lot of different records which they have their own maximum dates.