-- 오라클 기준으로 작성했습니다. -- ROW_NUMBER() OVER() 함수 검색하시면 됩니다. WITH T ( ACCT_DT ) AS ( SELECT '20190101' FROM DUAL CONNECT BY LEVEL <= 10 UNION ALL SELECT '20190102' FROM DUAL CONNECT BY LEVEL <= 8 UNION ALL SELECT '20190103' FROM DUAL CONNECT BY LEVEL <= 7 ) SELECT T.* , ROW_NUMBER() OVER(PARTITION BY ACCT_DT ORDER BY ROWNUM) SEQ_NO FROM T