select a.Type, Sum(a.Money) as Money, b.Date as newdate
from temp a
left join (select type, max(date) as Date from temp group by type) b on a.Type = b.Type
where a.Date >= '2013-11-1' AND
a.Date <= '2013-11-5'
group by a.type, b.Date
[=EDIT=] due to the OP's comment
SELECT t.Type, Sum(t.Money) as Money, Max(t.Date) as NewDate
FROM Table t
WHERE Date >= '2013-11-1' AND
Date <= '2013-11-5'
Group By t.Type
[=EDIT=]
Good luck,
OI