สอบถาม เกี่ยวกับการ Select SQL ข้อมูลจากตารางหน่อยครับ

SELECT *
FROM `tbl`
WHERE id NOT
IN (

SELECT id
FROM (

SELECT id, min( date )
FROM `tbl`
GROUP BY name
)a
)

<?php
	//-- ส่วนที่ดึงมาจากฐานข้อมูล ในลูป while
	$data['A'][] = array('Id' => 1, 'Name' => 'A', 'Date' => '2013-01-01');
	$data['A'][] = array('Id' => 2, 'Name' => 'A', 'Date' => '2013-01-02');
	$data['A'][] = array('Id' => 3, 'Name' => 'A', 'Date' => '2013-01-03');
	$data['A'][] = array('Id' => 6, 'Name' => 'A', 'Date' => '2013-01-04');
	
	$data['B'][] = array('Id' => 4, 'Name' => 'B', 'Date' => '2013-01-11');
	$data['B'][] = array('Id' => 5, 'Name' => 'B', 'Date' => '2013-01-15');
	$data['B'][] = array('Id' => 8, 'Name' => 'B', 'Date' => '2013-01-16');
	
	$data['C'][] = array('Id' => 7, 'Name' => 'C', 'Date' => '2013-01-01');
	$data['C'][] = array('Id' => 9, 'Name' => 'C', 'Date' => '2013-01-05');
	$data['C'][] = array('Id' => 10, 'Name' => 'C', 'Date' => '2013-01-06');
	//-- สิ้นสุดการจัดรูปแบบข้อมูลในลูป while
	
	//จัดรูปแบบข้อมูลใหม่
	$newArray = array();
	foreach($data as $row){
		$c = count($row);
		if($c > 1){
			for($i=1;$i<$c;$i++){
				$id = $row[$i]['Id'];
				$newArray[$id] = $row[$i];
			}
		}else{
			$id = $row[0]['Id'];
			$newArray[$id] = $row[0];
		}
	}
	ksort($newArray);//เรียงตามลำดับ ไอดี

	//echo '<pre>', print_r($newArray, true), '</pre>';
	
	echo '<table border="1" width="400">';
	foreach($newArray as $row){
		echo '<tr><td>' . implode('</td><td>', $row) . '</td></tr>';
	}
	echo '</table>';
?>