SQL max値の行全体を取得

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 <= TO_DATE('20020107')
GROUP BY ENAME )
;

(2) 分析関数を使用したクエリを親問合わせにしたクエリ
SELECT WK_DATE, ENAME, MAX_WK_TIME FROM
( SELECT WK_DATE, ENAME, MAX(WK_TIME) OVER (PARTITION BY ENAME) AS MAX_WK_TIME
, WK_TIME
FROM EMP
WHERE WK_DATE >= TO_DATE('20020101')
AND WK_DATE <= TO_DATE('20020107') )
WHERE WK_TIME = MAX_WK_TIME
;

http://dalmore.blog7.fc2.com/blog-entry-20.html

SELECT * FROM Test A
WHERE
NOT EXISTS
( SELECT *
FROM Test
WHERE Type = A.Type AND Value < A.Value )

http://homepage2.nifty.com/sak/w_sak3/doc/sysbrd/sq_kj04_3.htm

overの使い方いろいろ