table1idname1a2b3ctable2idnamecont1aaa2bbb3aaaaaSELECT*,count(distincttable2.name)FROMtable1,table2WHEREtable1.name=table2.nameGROUPBYtable2.nameORDERBYtable2.idDESC";重復...

table1

id name

1 a

2 b

3 c

table2

id name cont

1 a aa

2 b bb

3 a aaaa

SELECT *,count(distinct table2.name) FROM table1,table2 WHERE table1.name = table2.name GROUP BY table2.name ORDER BY table2.id DESC";

重復的記錄是過濾掉了，現在問題是我要的是table2中重復的name=a的ID最大的cont=aaaa的內容。

每次讀出來的都是name=a ,cont=aa的內容。。。

$sqlcha ="SELECT *,count(distinct crm_followinfo.FOL_Comname) FROM crm_customers,crm_followinfo WHERE crm_customers.CUS_Comname = crm_followinfo.FOL_Comname GROUP BY crm_followinfo.FOL_Comname ORDER BY FOL_Id DESC";

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $sqlcha, $startRow_Recordset1, $maxRows_Recordset1);

$connn = mysql_query($query_limit_Recordset1, $conn) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($connn);

在這個表crm_followinfo 有個FOL_Id字段 ， 如何除掉重復后，顯示最大的FOL_Id的這條記錄呢？

展開