안녕하세요 구문에서 avg_size 에 소숫점 2자리 까지 표기했으면 합니다. 살펴주세요. sql="select l2,sum(size) as total,count(*) as cnt,sum(size) / count(*) as avg_size from [TEST.dbf] Group by l2"
감사합니다.
select l2,sum(size) as total,count(*) as cnt,Round(sum(size) / count(*),2) as avg_size from [TEST.dbf] Group by l2
ㄱ ㅏ ㅁ ㅅ ㅏ 합니다. ^*^