반응형 세로 쿼리1 2개씩 홀수, 짝수로 가로 뽑아서 세로로 세울때 2005에서만 가능함 명구선배님 쿼리 with h_gub_rule1CTE (rownum , plusname , scode , sname) AS ( select row_number() over(order by gub_scode) as rownum , a.gub_scode + '@' + b.sd_name as plusname , a.gub_scode as scode , b.sd_name as sname from h_gub_rule as a left outer join h_sudang as b on a.gub_gubun = b.sd_gubun and a.gub_scode = b.sd_code WHERE a.gub_gubun ='01' and a.gub_month ='200811' and {fn substrin.. 2008. 11. 20. 이전 1 다음 반응형