Select all rows by max date

select-rows-by-max-date.sql

/* --------------------------------------------------------------
 DB MODEL
 
 ID   Type_id    Name      Value           Date
 --  --------   ------    -------         ---------------------
 1      56      "name1"   "lorem"         "2011-03-19 22:08:13"
 5      58      "name2"   "ipsum"         "2011-03-19 22:00:44"
 22     58      "name2"   "dolor"         "2011-03-20 11:03:13"
 31     25      "name3"   "sit"           "2011-04-28 18:42:07"
 44     12      "name4"   "amet"          "2011-04-12 11:06:11"
 98     45      "name5"   "consectetur"   "2011-03-19 22:46:04"
 211    12      "name4"   "adipiscing"    "2011-03-19 22:25:24"
 217    25      "name3"   "elit"          "2011-03-19 22:25:24"

 -------------------------------------------------------------- */

SELECT * FROM my_table
INNER JOIN (SELECT Type_id, MAX(Date) as TopDate FROM my_table GROUP BY Type_id ) AS EachItem 
ON  EachItem.TopDate = my_table.Date 
AND EachItem.Type_id = my_table.Type_id;