Table
For MSACCESS , DB2 , MSSQL or MySQL
SELECT T1.name, T1.sur, T1.date_GO, T3.MaxD
FROM Table1 AS T1
INNER JOIN
(SELECT T2.NAME , MAX(T2.date_GO) AS MaxD FROM Table1 T2 Group by T2.Name) AS T3 ON (T1.date_GO = T3.MaxD) AND (T1.name = T3.Name);
Resulted
ไม่มีความคิดเห็น:
แสดงความคิดเห็น