Want to get records with Latest date

[garrisonian14]

Hi Friends,

I need urgent help. I have a table which have following data.

Type name address date

1 Ali street1 2008-02-02
1 mac street2 2008-02-07

2 fash street3 2008-02-02

2 has street4 2008-01-10



i want to wtite a query that returns latest record of each type.

In the above case it must return

Type name address date

1 mac street2 2008-02-07
2 fash street3 2008-02-02


i need urgent help. Please can you write a query for me.

[abduraooft]

select type,name,address,date from table_name order by date ASC group by type, have a try!