재귀쿼리 썸네일형 리스트형 [MSSQL] 재귀쿼리 WITH NUMBERS(DAYS) AS (SELECT CONVERT(DATE, '20100218') AS DAYSUNION ALLSELECT DATEADD(DAY, 1, DAYS)FROM NUMBERSWHERE DATEDIFF(DAY, DAYS, CONVERT(DATE, '20181015')) > 0)SELECT DAYS FROM NUMBERS ORDER BY DAYS DESCOPTION (MAXRECURSION 4000) 날짜 뽑는 재귀쿼리 예제 더보기 이전 1 다음