2007-04-16 RANK()関数を使用してみる > SELECT * FROM ( SELECT USR_SEQ, APPLY_DT, ENTRY_DT, APPLY_SEQ, RANK() OVER(PARTITION BY USR_SEQ ORDER BY USER_SEQ, APPLY_DT DESC ,ENTRY_DT DESC, APPLY_SEQ ASC) RANK_NO FROM APPLY WHERE ) WHERE RANK_NO = 1