MDB.기타 - rownum 구하기

[ MDB.기타 - rownum 구하기 ]

 

 

SELECT CONTEST_DATE FROM (SELECT (SELECT COUNT(I.CONTEST_DATE) FROM TContest I WHERE I.CONTEST_DATE >=O.CONTEST_DATE) AS ROWID, CONTEST_DATE FROM TContest O) WHERE ROWID <= 1 )