<?php include("connection.php"); 
$sor = mysql_query("select name,id from students where name in (select name from students group by name desc) Group by name order by id desc") ;
while($yaz=mysql_fetch_array($sor))
{
echo $yaz['name']." = ".$yaz['id']."<br>";
}
?>
Çıktı
aa = 72
eiuaeia = 69
iuauea = 68
aiueaiuea = 67
birde bunu denermisin