how to get the distinct records based on maximum date?

Vote count:

0

I'm working with Sql server 2008.i have a table contains following columns,

    Id,
    Name,
    Date

this table contains more than one record for same id.i want to get distinct id having maximum date.how can i write sql query for this?

asked 1 min ago

user2514925

145