Max1 MAX() 함수의 성능 개선 -2 1. 사전구성 SELECT CASE WHEN a.number < 10 THEN '가' ELSE '나' END AS A , ROW_NUMBER() OVER(ORDER BY a.number) AS B INTO TB_TOP FROM master..spt_values a JOIN master..spt_values b ON a.type = 'P' AND a.number 2022. 12. 19. 이전 1 다음
