2007-04-16から1日間の記事一覧
> 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
> 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