http://tsubosak.hp.infoseek.co.jp/1-10/12-select.html(1) サブクエリ SELECT WK_DATE, ENAME, WK_TIME FROM EMP WHERE ( ENAME, WK_TIME ) IN ( SELECT ENAME, MAX(WK_TIME) MAX_WK_TIME FROM EMP WHERE WK_DATE >= TO_DATE('20020101') AND WK_DATE GROU…