SELECT 
	x1.* 
FROM (
	SELECT 
		*, 
		ROW_NUMBER() OVER (PARTITION BY name ORDER BY date DESC) AS rowNumber
	FROM 
		mytable
) AS x1 
WHERE 
	x1.rowNumber = 1