/****** YYYYMMDD(NUM), CHITEN(TXT)フィールドに付きNICHIJI(TXT)フィールドの最大値を取得 ******/ //共通 SELECT * FROM TABLE1 WHERE TABLE1.NICHIJI2 = (SELECT MAX(TMP.NICHIJI2) FROM TABLE1 TMP WHERE TMP.YYYYMMDD=TABLE1.YYYYMMDD AND TMP.CHITEN=TABLE1.CHITEN) //SQL Server SELE ...