MS ACCESS ใช้ SELECT Field1 + Field2 + ' ' + Field3
DB2 ใช้ SELECT Field1 || Field2 || ' ' || Field3
MySql ใช้ SELECT CONCAT(Field1,Field2,Field3)
Table
Sample
SELECT T1.name+'<-->'+T1.sur AS Expr1, 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.name = T3.Name) AND (T1.date_GO = T3.MaxD);
ไม่มีความคิดเห็น:
แสดงความคิดเห็น